Form Criteria Prompting

  • Thread starter Thread starter Howard
  • Start date Start date
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
 
SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID =
Customers.CustomerID WHERE Customers.LastName = [Enter Last Name:]

Cheers,
Pavel
 
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.
 
Back
Top