Getting to "Criteria" of Query

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

Guest

I have created a button to run a query on a form. I want to incorporate data
from the form to populate the criteria of the Query. How do I access the
criteria of a Query in code form?
 
Kou said:
I have created a button to run a query on a form. I want to incorporate data
from the form to populate the criteria of the Query. How do I access the
criteria of a Query in code form?
Click to expand...


Set the criteria under the appropriate column to reference
the corresponding form control. For example, the
CompanyName field in the query might have a criteria like:
=Forms!yourform.companynametextbox
to filter the query's dataset to company specified in the
form's text box.
 
Back
Top