Inputting text box information into Query criteria

[chanman525]

Just a quick question. I have a calendar control on a form and two text boxes. When you click on a text box and then click a date on the calendar, the date is inputted into the text box.

I have a query that I'm trying to run off of these two dates in the text boxes but I can't seem to figure out how to use them properly.

In my query criteria I have it as

Between [frmMain]![txtstartdate] And [frmMain]![txtenddate]

Whenever I hit the command button to run the query, a blank box pops up that says txtstartdate.

Can anyone help out with the correct criteria to make my query work?

 

[Remou]

Have you double-checked that the name of the textbox on the open form is exactly txtstartdate?

 

[PHV]

Perhaps this ?
Between [Forms]![frmMain]![txtstartdate] And [Forms]![frmMain]![txtenddate]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

Please ignore my last post. You need Forms!

Between Forms![frmMain]![txtstartdate] And Forms![frmMain]![txtenddate]