• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Power Subform Techniques

Many new Access developers don't know the ins and outs of creating and modifying a subform and referring to subform controls, so first look at some important points you should know when working with subforms:

  • The easiest way to add a subform to a main form is to open the main form, then drag and drop the subform onto the main form.

  • The easiest way to edit a subform after it has been added to the main form is to double-click on the subform control within the main form. If your double-click isn't successful, you need to click off the subform object, then double-click on it again.

  • The subform control's LinkChildFields and LinkMasterFields properties determine which fields in the main form link to which fields in the subform. A single field name, or a list of fields separated by semicolons, can be entered into these properties. When they are properly set, these properties make sure all records in the child form relate to the currently displayed record in the parent form.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint