Items being removed from a Combo Box

[viper]

Greetings I'm new to this forum and I've been designing Database for 5 years now and I'm still learning new techniques. My apologies if this problem has been asked before but I was having trouble finding it in the forums.

Question:
I am creating a DB where we can issue and log ID badges to visitors coming into our facility. What I would like to do is when you’re checking out a badge for some, one you have a drop down box with the available badges, once one is assigned it is taken off the drop box to prevent some one inadvertently issuing a badge that has already been issued.

Right now I have created 3 tables that contain the numbered badges of the 3 types of ID badges we have. I then have a table to enter the info on who checked out the badge and at what time. What I would like it’s to have the issued badge removed from the drop down when selected then repopulated when the badge is returned once the person has left.



If this is possible I would be grateful of any help or ideas on alternative work around, thank you in advance

Regards, viper

[weekend00]

I assume your drop down box data is from a table with badges and status, only those with status "not issued" are listed in the box. when badge is issued or return, you change the status.

All right, you've done all of above, then what you need to refresh the list is issue a requery command after you change the status:

combo1.requery

[viper]

Ok so I have a table for the badges with the status for each badge. I then created a query and set the criteria for "Not Issued" so that once a badge's status is changed its taken off the list. I then created a dropdown box using the new Query on my Event table. But once I creat another query to tie in all the tabels it locks it up so that i can't add new records or change existing records. I have played around with the relationships to see if that was my issue but so far its not working any ideas?

Thanks