A
Ashby
One procedure would be to pass the information in the two
fields to the query and then open the query to display the
records
To pass the fields to the query: In the query design
window; in the criteria fields for:
Name: Forms!YourFormName!FieldNameOnForm
Category: Forms!YourFormName!FieldNameOnForm
When the query is opened it will capture whatever is in
these fields and use it as the criteria for the query.
However, the form must remain open.
fields to the query and then open the query to display the
records
To pass the fields to the query: In the query design
window; in the criteria fields for:
Name: Forms!YourFormName!FieldNameOnForm
Category: Forms!YourFormName!FieldNameOnForm
When the query is opened it will capture whatever is in
these fields and use it as the criteria for the query.
However, the form must remain open.