Getting to "Criteria" of Query

[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?

 

[Marshall Barton]

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?

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.

 

[Guest]

See my post in "Programming", if it answer your question.