My form has a combo box labeled StoreID from my table tblStore.
My form's Record Source is tblPreliminaryBonus
tblPreliminaryBonus has a field (number) StoreID
This tblPreliminaryBonus is only a temporary table and all the records are planned to be deleted later.
Here's my objective. Everytime a record is written in tblPrelimiaryBonus I would like to repopulate my combo box to reflect only those stores where a Preliminary Bonus record does not have a corresponding StoreID in the Store table.
In other words, if I had 5 stores and one store has a Prelimiary Bonus record, I'd like to be able to show the four stores that have yet to have their own record in my combo box