trying to search by date 1

[kdoran]

Hello,

On a form I am trying to input a date (Text11) and have it find all dates in a table equal or greater than the date typed in. I could only make it find a specific date which I do not want

Here is what did not work

[Forms]![SearchfrmDate]>=[Text11]


What am I missing?

Thanks,

Kelly

 

[TomCologne]

In Query Design,tblXXX.Date, set the criteria to:
>=[Forms]![SearchfrmDate]![Text11]

You're not alone,

TomCologne

 

[kdoran]

Hello TomCologne,

That worked out great.

Thanks,

Kelly