how to prompt from a query?

E

Elsie

Hi all, I came across a select query whereby when you double-click on it, a
msgbox will prompt to enter some item code to search before it displays the
required results.

How do I go about constructing such a query?
 
K

Ken Snell [MVP]

It's called a parameter query. It can be done very easily by putting text
inside [ ] characters:

SELECT * FROM Tablename
WHERE Fieldname = [Enter the desired value:];
 
Top