In the Northwind database, open the Tools menu and click Relationships. In the Relationships window, note that the Customers table has a one-to-many relationship with the Orders table, whereas the ...

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

The subform is an extremely useful device that is surprisingly easy to create. The Northwind.mdb sample database has a form that uses not one but two subforms. Launch Access and click Help, Sample ...

The SetFocus method moves the focus to the specified form, the specified control on the active form, or the specified field on the active datasheet. Use the SetFocus method when you want a particular ...

Hi all. Am trying to do something for which the wheel must have already been invented, but hit a snag (Access 97). A form contains a subform. The parent form is used for selecting clients. The subform ...

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. Find out ...