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

Use the Form property to refer to a form or to refer to the form associated with a subformcontrol. Read-only Form. This property refers to a form object. It's read-only in all views. The next example ...

expression A variable that represents a SubForm object. Use the Subform/Subreport Field Linker to set these properties by choosing the Build button to the right of the property box in the property ...

Create a pop-up form in Access 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 ...