query criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a button on a form which runs a query. This query
needs to be based upon a field from a form that the button is to be on, so
that when the query runs, only records relating to this one field are shown.
 
I assume you know how to run the query from the button click
DoCmd.OpenQuery etc.

In the criteria row of the columns in your query you can refer to fields on
your form like this
[Forms]![FormName]![FieldName]
 
You must log in or register to reply here.

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

Similar Threads

Changing query criteria to supply a form 3
Parameter Query Won't Run 0
update query using like criteria 3
Use In() Expression as Query criteria with guts from Function 1
Access Dcount (multiple criteria) 3
Criteria in a Querie 8
Combobox for criteria help 5
Access Access Report Works on One Machine but not Another 3

Back
Top