Parameter Queries


Queries that display a dialog box that prompts the user for a parameter value are referred to as parameter queries.  

For more information on parameter queries, simply search for that term using Access help and select the subject "Create a parameter query that prompts for criteria each time it's run."

 

An example of a parameter query is shown below.  Note that the prompt is enclosed in square brackets.

SELECT MEMBER.Mem_Phone
   FROM MEMBER
       WHERE MEMBER.MemberID = [Enter Member ID: ];