Deleting records from a form using combo box

[daverskully]

What code do I need to delete a record using a form and a combo box. I need to be able to link the selection in the combo box to a button that, when pressed, will delete the selected record.

Information:

Account Executive Combo Box - select an account executive based on a table (that contains only account executives and an autonumber)


Table name: AccountExecutives
Form name: DeleteAccountExecutive
Combo Box name: Combo300
Button name: DeleteExecutive

 

[Dennisk]

the best way is to delete the current record (although perceived wisdom is not to delete but just flag as deleted).

Use the Combo box wizard to generate a combo box that will find a record.

Use the command buttom Wizard to generate a delete button.