form info to query

  • Thread starter Thread starter jeff
  • Start date Start date
J

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.
 
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
 
Back
Top