combo box selection

[accessuser1308]

I currently have a combo box on a form. The combo contains a list of parts.
When a part is selected it stores the value on my form. At the same time it
displays the full part description/info on a subform.

What I would like to do....
If a part is selected (thus stored in the 'part' field on my table/form) I
would like that part to be removed from the combo list on all new records
(form/table). At the same time, if a mistake was made and the part changed I
would like the "incorrect" part to return to the list and have the "correct"
part removed from the list.

Any help is appreciated.
Thank you

 

[Bill Mosca]

The standard way to "remove" a record is to put a field named Available or
maybe Active in the table and use it to indicate the status of your part.
That way you do not lose any related records and there is clean audit
trail.

Selecting the item and then running an update query with that item's ID
would be the simplest way.

As to undoing the "deletion", I'd include a pop-up form with a combo box of
all the inactive part IDs so the user can select the part and do another
update to change the status again.