Sometimes I miss the obvious and with Microsoft Access 97 subforms this was one of those times, so if I did not know this, then the chances are some of you also do not know this. Others will know this tip and will wonder how others could possibly not know.
I work across many different versions of Microsoft Access - 97 upwards to the latest version of Microsoft Access. 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 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.