Problem with unbound date field

[Digger442]

I have created a form that has an unbound field into which I'd like the user to be able to enter date parameters such as >5/1/07 or between 5/1/07 and 5/31/07.

A query is then run with a button on the form which looks for the criteria on the form.

If I enter a date by itself, it runs fine, but if I enter a qualifier for the date (>, <, or between x/xx/xx and x/xx/xx) I get an error msg "The expression is typed incorrectly, or it is too complex to be evaluated".

If I enter the criteria directly into the query it works fine.

What am I doing wrong?

Thanks!

 

[missinglinq]

We need to see the code you're using to assign the criteria to the query.

Linq

 

[Digger442]

Hey Linq,

Thanks...I think I found the solution by digging back in the forums a bit. I amgoing to use "Between [Forms]![frmReports]![txtStartDate] And [Forms]![frmReports]![txtEndDate]" and the user will just have to deal with not using < or >. Seems to work fine.

BTW....I'm here in C-ville...howdy neighbor.

 

[missinglinq]

Glad you got it working!

How are things in Tom's Town?

Linq

 

[Digger442]

You know this place...too stuffy for it's own good...at least they've stopped wearing suits and ties to the footballs games.

Thanks again....