Like

[brin]

I have a querie with a list of clients, is there a fuction i can use where i run the querie and i am prompted to insert a client name for example "smith" and i can get the list of all smiths in the table????

 

[emcf]

..i think using the following expression in the criteria box on the relevant field in your query -

like []&"*"

..this should prompt the user to enter a name, eg

type in "Smith" and every entry under the name of Smith will be brought back (along with any smithsons, smithers etc).

if you just want to bring back exact matches then just add -
like []

i'm sure there is a smarter way to do this, however the above is what i've used successfully in the past.

 

[Vassago]

You don't have to make it say just

Like []

You could actually put in a name there, such as

Like [InputName]

As long as [InputName] isn't a field on one of your tables used in the query, the query will prompt you to enter what inputname is equal to.

Also, you could create a separate table with a text box, and then make it create the query, but that's much more advanced.