XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google

Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index


Access 97 subforms how to access them

Sometimes I miss the obvious and this is one of those times, so if I did not know this, then the chances are some or you also do not know this. Others of you will know and will wonder how others could possibly not know and it has to do with Microsoft Access 97 subforms. I work in four platforms of Microsoft Access - 97, 2000, 2002 and 2003. For those of you who have Microsoft Access 97, and have included a subform on your form, when you are in Design view, the subform appears blank (just a white square).

To work on the subform, I used to exit the main form then open the subform separately. I have just discovered that if you double click on the subform whilst in Design view of the main form, the subform will open. Now this may be simple to some of you, but if you do not know this then the other option can be quite cumbersome, so I thought this was worth a mention here.

Do you like this tip? Subscribe to my weekly Newsletter to receive tips weekly via email. Click Here to subscribe.

 

footer for Microsoft Access page