Combo Box Query Perameter

SORI

New member
Local time
Today, 09:05
Joined
Aug 27, 2013
Messages
6
HELP!
I can't figure this out I have a query where I want to use a combo box in the parameter. However, its not working.

SELECT Call_Details.Emp_ID, Call_Details.[Call Status]
FROM Call_Details
WHERE (((Call_Details.Emp_ID)=[Forms]![TTY_ID]![TTY_ID]));

I get this in the Parameter Value Dialoge

Forms!TTY_ID!TTY_ID

Should I be entering this in the criteria field at all? Do I have to build an event to make this work?:banghead:
 
The form needs to be open when the query runs. Is it? If so, either the form or combo name is spelled wrong.
 
It is open but I guess this is not the solution I am looking for.

I want user to be prompted with a combo box when running the query. Instead of typing the crieteria I want them to have a drop down menu!

I feel like I would need to build an event for this.
Thanks!:banghead:
 
Well, the parameter prompt means something is spelled wrong. If you want to be prompted with a combo, you need to build it with a form. The built-in prompt can't be configured to be a combo.
 

Users who are viewing this thread

Back
Top Bottom