How do I remove an option in a combo box once its selected.

[ssgtdelvalle]

I am a US Marine and I am building a database to keep track of all the weapons in the Armory. I have multiple tables but to keep the question simple im only going to talk about 2.

I have the main table where all the raw data is stored, I also have the pistol table which all pistol serial numbers are stored. I have created a form to input information that will be stored in the main table. In that form i have a combo box that looks up information from the pistol table and stores it in the main table. In essence I am issuing a pistol to each Marine in the battalion how do I remove the serial number from the combo box once it has been selected, so that the next time I go to issue a pistol it only shows the pistols available for issue serial numbers not in the main table?

[Robeen]

I suggest adding a 'Yes/No' field to the Pistol table and naming it something like 'CheckedOut' [for example].

When you give a pistol to a Marine - you put a 'Yes' in the [CheckedOut] field of the Pistol table [meaning it IS checked out].

Then - change the Row Source of your Combo Box so that it says something like ' . . . Where [CheckedOut] = False'.
This will limit the pistols displayed to those that are not checked out.

Hope this helps.