StryderLlama
Registered User.
- Local time
- Today, 05:23
- Joined
- Oct 26, 2007
- Messages
- 19
I have a form that I need to have a field where the user can type text. I want to link that field to the "Criteria" field on a query that will then search for the text. I know how to do this by building an event in the query linking that field on the form to the criteria field on the query. The problem is I need the criteriea to also look at the text as a Like statement.
For example:
On the form, the user types in "Ice" to the text box text0
In the criteria field on the query I would like the search to look at text0 as a Like statement. So the criteria field would look like this
Like '*[Forms]![Query Name]![Text0]*' the idea being that the query would look for anything containing the word "Ice" in the text.
In my illogical mind this would work, but it is not. I am not sure if this is just a formating issue or if what I am trying to do is not possible.
The records I am performing the search on ar over 400k records. So I cannot create a list box, It needs to be searchable somehow but simple for the user. Any thoughts would be much appreciated.
For example:
On the form, the user types in "Ice" to the text box text0
In the criteria field on the query I would like the search to look at text0 as a Like statement. So the criteria field would look like this
Like '*[Forms]![Query Name]![Text0]*' the idea being that the query would look for anything containing the word "Ice" in the text.
In my illogical mind this would work, but it is not. I am not sure if this is just a formating issue or if what I am trying to do is not possible.
The records I am performing the search on ar over 400k records. So I cannot create a list box, It needs to be searchable somehow but simple for the user. Any thoughts would be much appreciated.
