Search range of date in Query-by-Form

[BigL]

I can search for ranges of dates OK in queries and by coding for specific searches. But I cannot seem to be able search for range of dates or > dates in query-by-form mode in Access projects.

Access projects enclose the filter expression in double quotes. Ie: Me.filter= ((DateField="09/26/01')) which works fine. But when I try so say >09/26/01 in the query by form mode the filter applied is ((DateField=">09/26/01&quot) which errors out.

Any ideas short of coding for specific searches?

 

[CosmoKramer]

Try:

((DateField > #09/26/01#))

 

[BigL]

Thanks, but been there, done that.

I get((DateField=">#09/26/01#&quot) which also errors out. Works Ok in an MDB but not in an ADP.

Any other ideas?