Edit A table entry from a combo box selection in VBA

[Tom d]

I want to select a authors name from a combo box and edit that persons name. Example name was misspelled. I would like to add it to the Authors FRM

 

[Gasman]

I would put the values from the combo entry into textbox controls so as to be able to edit.
Those controls could be bound to the table or not.
Then requery the combo.
Save the entry, so you can go back to it after the requery.

 

[Pat Hartman]

Your application needs better flow. I've included a link to a tiny sample application which is an Address Book. It shows how you can both view and edit records. Your interface does not provide any way to edit existing records and you are struggling with that.

The letter buttons at the bottom of the form can be used to filter books as well as addresses and the department combo could be used to filter by category.

Address Book

Address Book with alphabet buttons, a sort option, and a different filter option as well as two reports.

www.access-programmers.co.uk