combo box assignments

Can anyone tell me how to allow a user to select an item in a combo box on a form, that item gets automatically assigned to the current record and, at the same time, make the item unavailable (preferably not shown in list) until it's unassigned from 1st record? I have a Staff table & a Keys table, which contains lockers & peds (filtered by 2 qrys to fill 2 combo boxes. Users can have 1 of ea but no dup#s assigned. LDV
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!