Change a string into a criteria expression

[wesmorgan7]

Here's one that has me stumped, although I'm sure there's an easy solution:

I have a form with a textbox control that contains a string, such as "[Date]" or "Between #5/2/2007# and 5/10/2007#"

Trying to use the string from the textbox as a criteria in a query (that references this textbox control), but currently it is not working.

I think it may be that somehow the string needs to be converted into an expression, so that instead of the query looking for records that match the text "[Date]" it will actually allow all the records in the [Date] field.

Any ideas?

Thanks for your help.