Change a string into a criteria expression

W

wesmorgan7

Joined
Jul 18, 2007
Messages
2
Reaction score
0
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

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
VBA: How can I use a string variable as autofilter criteria? 4
passing a parameter based on multiple selections 7
Query using multiple values from one text box 7
Using Variable as criteria 4
Parameterised query to return all records or those Between two val 2
Criteria for select query. 2
Use a function in the "Criteria" of a query? 3

Top