new user - possible query question

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top