Combo Box only show names not used

[Mtyetti2]

Hello!



fairly new at Access, but hoping someone can help me solve my issue with an employee scheduling database I made.
i would like a combo box, which pulls employees names based on a table, to filter itself to show only employees that have not been used yet. Ie: show employees that have yet to be scheduled.

Thank you soo much, everyone.
Scott

[Micron]

should be simple enough, but not enough info provided by you to be specific. So generally, you'd create a sql statement or query that filters out the ones that haven't been scheduled. If that's a Yes/No type of field, then you return those who are "no". If it's a date field, you return those who have no schedule dates set. Then set the row source of the combo to be that query, or copy the sql statement into the row source field on the property sheet.

[June7]

Build query that includes Employees table and Scheduled table. Basically a 'Find Unmatched' query.

[Mtyetti2]

Thanks for the quick reply. I’ll try to provide a little more detail.

I'm scheduling employees for class sessions. Ie: Thursday, 4pm, Friday 5pm, etc.
As I populate these sessions with the employees, I would like my combo box to exclude the names that are already scheduled. That way I avoid scheduling them twice.
I would like this to be done automatically as the sessions are populated, so I don’t think a yes/no field will work.

thanks again!

[Mtyetti2]

This may work. Can you provide any more info on how to start the unmatched query? I’m fairly familiar with queries, just not how to make the unmatch.

[ssanfu]

In the menu, click on
Create / Query Wizard / Find Unmatched query.