Now that I'm shifting that balance, I'm finding ways ot do things in VB that are pretty much taken for granted in Access.<P>Like subforms. I have a code routine for opening and positioning a form on a ...

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 as ...

probably not, but i'm sure you can use code to navigate back to the record that it was on. check out using bookmarks (i think that's what they are called).

My problem looks simple but I can't get it done properly. I have a main form with two subforms, Internal sales & External sales. Both forms have total boxes in the footer, Total internal sales (TIS) & ...