Like Query

[daybase]

Simple one - I use a like query to filter quite a large table of names to help the user find the right client. Works fine but the query produces a message box with a title bar Enter Parameter Value - not very user friendly. Simple question (I need simple answers too) how/where can I change that massage?

Very new to all this and everything is pretty much still trial and error stage so any suggestions for better methods greatly appreciated but please keep it simple.

 

[PHV]

Use a form as a front end to your query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[daybase]

Not entirely sure what you mean sorry.

 

[RdmName]

There are probly many messages around here detailing how to accomplish but here is one way I did it..

Use whatever event you need to to open your form..
Button.. Onclick whatever, In your query set the value of the name you want to find to the text box name in the form you create..

query:
Name=[forms]![created_form]![textbox].value

so that when you run the query it asks for the name of the form and looks for a value in the text box..

form:
create a button that runs the query, and then closes the form.

The query runs, sees the form and finds the data. Query returns results.
thats it..

I dont have it in front of me or I would put it in verbatim but hopefully that will put you on the right track.