Creating tabbed forms

[cgemmill1]

I am trying to create a form where you select an orgnaization at the top of the form and then all the tabs displays that orgnaizations information. For example the tabs would include contact history, reports, demographic information. How can I make this happen? DO I need to use a set of queries? I want the data to change then the organization changes.

 

[pbaldy]

Typically you'd use subforms based on the related tables. The subform control's master/child links keep the subform in sync with the main form (if you use the wizard to add a subform, it will ask about linking fields).

 

[cgemmill1]

Are you referring to the forms wizard because I only see basic types of forms and not subforms.

 

[pbaldy]

No, when you have the main form in design view, there's a button on the toolbar/ribbon to add a subform, just like there are buttons for labels, text boxes, etc.