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.
WHERE MEMBER.MemberID = [Enter Member ID: ];