New User!How do I tie textbox text into the expression of my query?

[jc8317]

I have a form with an active x calendar control, a text box and command button.

I have a query designed, how can I click the command button to open my query using the Date in my text box.

I need to know what to use in the expression in my query to make it read whats in the text box.

I am querying by date.

any help would be much appreciated.

 

[tempclerk]

Forms!FormName![text box name] in the criteria of your date field.

 

[nickjar2]

Either try in the criteria in the query:

"#" & forms![nameOfForm]![Name of text box] & "#"

or just

forms![nameOfForm]![Name of text box]

Can't quite remember which one. The form will need to be open though for this though.

Nick