hi... i have this combo box that im using to display an employees information in a form, the combo box is in the header and the information to display is in the detail, what someone sugested to me is that i use a query i did it, but when i go to the combo box wizard and make it look up a table or a query, i put in the query that i made put the field that i want in this case is Employee_ID it tells me "No Value Given for one or more requiered parameters"
the query goes like this
Show is un checked
If I am reading your message correctly, it looks like the source for your combo box is a query in which the criteria is the value in the same combo box. Your Combo box is trying to get values from a query that is trying to get a value from the combo box. Nothing from nothing leaves....nothing.
I am assuming you want to pick an employee from the combo box and have the details appear in the detail section of the form. First remove the criteria from Employee_ID in the query and check it to show so all employees appear in the combo box. If you don't want that ID to be in the combo box, remove that column from the box (or recreate the box without that column).
Put a macro or event procedure in the OnClick event for the combo box that will requery the form with the record chosen in the combo box.