We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
(Note: Although these are Access tips, they're not all exclusive to Access.) You hear it so often, it's almost a mantra: Limit the data you retrieve. Limit the data retrieved by the form's underlying query or procedure. Then, populate controls to display only the fields necessary.
The Filter property of forms (introduced in Access 95) makes it easy to filter a form based on a control in the form.
However, the simple filter cannot be used if the field you wish to filter on is not in the form.
For example, some products might have several suppliers.
You need a subform for the various suppliers of the product in the main form.