Only show values in Comboxbox that pertain to the employee's record

[superjeff]

Hello
A query based form is used for tracking the different EVENTS, LODGING data, EMPLOYEE personal data and FAMILY members. I'd like to creat a combo box that shows only the events that the employee attended, not all the events in the EVENT_JUNCTION tbl. I would greatly appreciate your time and direction.



Respectfully,
Jeff

[Bob Fitz]

Can you post a copy of the db in A2003 format.

[superjeff]

I wish I could... Maybe a better description.
I have a master form with four subforms. The main form is Emloyee information. The subforms relate to Events that they might have attended. I have a unique name for each event that sits in a combobox and after their Name is queried I can select one of these unique event names and see their record for that event. The problem is, I will soon have many events. How can I show only the events that pertain to that person in the combobox after I pull up their name?

Thanks again for your help,
Jeff

[Bob Fitz]

If the combo box is populated by a query that shows all the events attended by all employees, then this query just need a WHERE clause added that references the Employee ID on the main form.