Combo Box Query Perameter

[SORI]

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:

 

[pbaldy]

The form needs to be open when the query runs. Is it? If so, either the form or combo name is spelled wrong.

 

[SORI]

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:

 

[pbaldy]

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.