About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
I have taken weekend express Access classes.
I am working from a book, "Mastering Access 2002 Desktop Development" Alison Balter.
I work for a not for profit agency that helps homeless families learn to become self sufficient.
As grants manager, I find a need for an evaluation application to measure client success.
So I am developing one from scratch.
I am currently creating the entry form and within it, a subform nestled in a subform.
I want the nestled subform(fsubChildSchlInfo) to automatically expand, for data entry, upon tabbing the last field (txtClientID) in it's master form (the form it's nestled in).
I did a basic macro event on the txtClientID:
On Got Focus.......mcrOpenfsubChldSchl
This opens the subform rather than just expand it.
I have only done some very simple macros and VBcode, but am slowly teaching myself.
Any suggestions?
Also, on the subject, is there a website of opensource macros/VBcode to help me get through this?
Thank you very much for your consideration.
Robin
Answer Hi
Are you trying to resize a subform in a main form?
If so you'll need to set exact sizes for the width and height.
This is not a normal way to handle a subform - as Access isn't very good at screen real estate issues when rezized (i.e. where and how to appear on screen at run time)
Can you tell me what data you have to expand on that you need this? I may be able to offer you an alternative approach.
