date from text box as query criteria

  • Thread starter Thread starter papa jonah
  • Start date Start date
P

papa jonah

I have a text box called:
[Forms]![query form]![txtSearchDate]

I have a query that I want this text box to feed. I want the query to
look at everything that is greater than the entered date.
I have tried syntax such as
#[Forms]![query form]![txtSearchDate]#
Click to expand...
That does not work.
How should I enter the syntax.
 
Is the textbox formatted as a Date? If yes, then this should work:
[Forms]![query form]![txtSearchDate]
Click to expand...

If not, or if the above is not working, then try this:
"#" & Format([Forms]![query form]![txtSearchDate], "mm/dd/yyyy") & "#"
Click to expand...

--

Ken Snell
<MS ACCESS MVP>

papa jonah said:
I have a text box called:
[Forms]![query form]![txtSearchDate]

I have a query that I want this text box to feed. I want the query to
look at everything that is greater than the entered date.
I have tried syntax such as
#[Forms]![query form]![txtSearchDate]#
Click to expand...
That does not work.
How should I enter the syntax.
Click to expand...
 
Back
Top