Change a string into a criteria expression

Jul 18, 2007
Reaction score
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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question