Referencing a control on an Access form is easy. Referencing a subform and its controls is a little more complex. To Access, a subform isn't a form at all, but a control, so you must reference it ...

So here we go...<BR><BR><B>The Overview:</B><BR><BR>frmMain, which has a subform control named sFrm. sFrm's SourceObject = "frmSearch"<BR><BR>frmSearch, which has a button named cmdSearch and a ...

OK...I've historically spent more time in Access VBA than in proper VB. Now that I'm shifting that balance, I'm finding ways ot do things in VB that are pretty much ...

If users need to access data that is not on their forms, you could add a subform; or, you can add a command button that, when clicked, will pop open the form that contains the necessary data.