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

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

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

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

I am trying to calculate the difference in 2 dates within a subform in MS Access. I have a start date and end date (usually a couple of days apart) driven from a seperate table / form with drop-down ...

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