Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub Forms

Status
Not open for further replies.

ryne23

Programmer
Mar 9, 2001
29
US
Is there a way to link sub forms to a main form so it is only pulled up when the user enters a field that pertains to that sub form?
 
the easiest way is to create your form, then create your subform.

Then in the design of your main form, use the subform control ( on the control toolbar) it will act as a wizard. select your existing subform, and then it should show you what it can see as fields to link on. If you don't like them, go to the subform properties, as it sits in the main form design view. In it properties, set the master field and child field links as you wish.


misscrf

It is never too late to become what you could have been ~ George Eliot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top