Navigation Form - Multiple Forms - 1 Prompt Filter

[nicko14]

Hello,



I want to create a navigation form that has multiple forms from multiple tables that are all filtered by the same ID that are related.

When I open the navigation form, I want it to prompt me for the ID #. Then from there I'm hoping all the forms will display only that ID's information and related data.

Is this possible? I'm not too good with VBA, I'm assuming the answer lies within setting an event procedure on the "on Open". Can anyone help?

Thanks,

Nick

[NTC]

Typically you set up a Main form, bound to the core table - and have those fields.

You create each of the eventual sub forms as stand alone forms.

Then you return to the Main form and insert the other forms as sub forms. During the insert the wizard will ask for the cross referencing ID field, unless you already set up the joins in table relationships.

In the main form one can either rely on the forward/backward navigation buttons in the frame of the form or set up a combobox to select a record.

Note that the main form must be single form - not continuous - as you can not have sub forms in a continuous form.

The term 'navigation form' typically refers to a form that holds buttons to open other forms and itself doesn't display any data....