Deleting Records (1 Viewer)

[kermit5]

I have inserted a delete command button on my form using the wizard. I have then written code to confirm the deletion.

When I click OK, that is that I want to delete the record, the record is deleted but the name of the project still remains in the unbound combo box that I use to select a record. How do I clear this name from the combo box after I confirm that I want to delete the record so the user can see that it has been deleted?

Scott

 

[boblarson]

In the code where you do the delete, once the delete has been accomplished do something like this:

cmbYourComboBoxName.Requery

That will requery the recordsource for the combo box and if the record is gone it should disappear from the combo box.

BL
hth