Form Criteria Prompting

H

Howard

In a query, I use the square brackets to prompt the user
for the criteria, eg [Enter Customer: ]
However, the field in question in the table and associated
query is a lookup field on another table which only has
two fields, Customer ID and Customer Name. Therefore when
prompted to Enter Customer, the user must enter the
customer ID number instead of being able to lookup which
customer. Is there a way to have a criteria prompt display
the field lookup?
-Howard
 
P

Pavel Romashkin

SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID =
Customers.CustomerID WHERE Customers.LastName = [Enter Last Name:]

Cheers,
Pavel
 
D

DanK

How about having a control listing the possibilities
(appear or already on the form )FIRST, where the user
chooses the choice they want, then run the query, pointing
the criteria to the control where the user has already
chosen from all their options.
 
Top