Query via form

B

Benuk73

Hi,

I've seen on other examples of access that you can search for specifi
data in a query via a form in a form of a pop up box. You enter you
criteria there instead of going into the actual query.

My question is, how do you go about setting one of these up?

Thanks in advance.

Be
 
N

Nikos Yannacopoulos

Ben,

In your query design, where you would normally type:
"Smith"
in the criteria line, under the Surname field, type in instead:
[Please enter surname to search for]
The square brackets instruct Access to ask for a parameter upon running
the query; the text in them is the prompt on the pop-up input box.

HTH,
Nikos
 
B

Ben

Is there any way to search for only part of the surname? For example "Smi..."
I would like to access records which are "Smith" and "Smitts" etc. Cheers.

Nikos Yannacopoulos said:
Ben,

In your query design, where you would normally type:
"Smith"
in the criteria line, under the Surname field, type in instead:
[Please enter surname to search for]
The square brackets instruct Access to ask for a parameter upon running
the query; the text in them is the prompt on the pop-up input box.

HTH,
Nikos
Hi,

I've seen on other examples of access that you can search for specific
data in a query via a form in a form of a pop up box. You enter your
criteria there instead of going into the actual query.

My question is, how do you go about setting one of these up?

Thanks in advance.

Ben
Click to expand...
Click to expand...
 
Top