form info to query

[jeff]

How do I get data from a form (let say from a "date" text
box) to be used in a query. My query always prompts me
for the date...I would rather enter a date in the form
and "On Update" of this field display the query.

 

[Duane Hookom]

The form must be open. You can create a new column in your query
NewCol: Forms!frmX!txtMyDate
or use the control in the criteria