In my form frmDesignatedEmployee I have a combo box, data type number, named StoreID from my table tblStore.
I am needing to create new records in my table tblDesignatedEmployee. This table has a field data type number named StoreID. I would like to evaluate BeforeUpdate my combo box to check to make sure that StoreID in my tblDesignatedEmployee has not been already assigned the same StoreID from the Store table. Then inform the user that this store has a designated employee already.
Why? I use an Insert Into query because I need to write four records concurrently.