Form Sequence

It is important when using query prompts and record picker controls on a data entry form that the controls have focus and are addressed by the user in the correct sequence. For instance, a control linked to a query prompt on the form must come before the record selector, so that a user can specify the necessary filter criteria that is used to populate the record selector with the correct database records.

Specifically, the sequence of controls on the form must be as follows:

Data entry controls bound to query prompts
Record picker control
Data entry controls bound to data sources

You can specify the sequence of controls on the form using the Tab Order property page of the data entry form.

You must also consider form sequence when you are creating a document with multiple data entry forms. For instance, it would be invalid to:

Have two forms where the second form is prompting the user for data that is required by the first form.
Have a query prompt on a conditional form, when a subsequent form requires data that might not be specified if the conditional form is not shown.

Related Topics