searching

I have a cross tab query set up which iwould like to search for a criteria which is input by a user. i have a form set up which includes a command button and a text box. I have been trawling through the Help but cannot find a solution, other than i need to use a parameter query, how do i set one of these up?

Hi

basically from what i know i would use a parameter query, unless i could see what you are trying to do i would recommned a parameter query which are very simple

kabir hussein

im also very simple, little help?

1.
The simpliest way to set up a parameter query is in the criteia portion of the field of the query, enter the following

[Input User Parameter for "Field Name"]


When you run the query a input box will appear with the message: Input User Parameter for "FieldName" and the input box will wait of the user to enter a criteria.

OR
2.
The other way (if the text box has the search criteria in it) is to enter the following in the criteria portion of the query

[forms]![FormName]![text1]

I would also recommend (personnal preference) putting a "like" command at the beginning of the paramater "like [forms]![FormName]![text1]" because this allows you to seach with wild card characters for example

L*
brings back

Lake
Loud
London

london
brings back

london

S-

thanx very much, out of at least 8 forums you are the only person to make sense

i am having problems setting up this "like" command. I have done exactly as you said but with applying it to my database so it reads "like [forms]![frm_AudioVisual_Search]![text9]" Any ideas as to where i am goin wrong?

never mind im an idiot. I thought the speech marks were required characters, d'oh

ravislayer

I noticed in the example you sent back to me you didn't rename you text field to something more meaningful

like [forms]![frm_AudioVisual_Search]![text9]

I would really recommend not using the default [text9] becuase it makes hard to trouble shoot later when something goes wrong. Also when you rename it put a "txt" in front of it to distungish it as a textbox

S-