how to prompt from a query?

[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?

 

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