how to prompt from a query?

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?

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:];

--

Ken Snell
MS ACCESS MVP

"Elsie" wrote in message
...
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?