In Access how can a listbox select and display a record on the same form and allow me to edit?

Question

Hello Everyone,

how can I make a listbox select and display a record on the same form and allow me to still be able to edit?

I want the list box to only display the empname and once I click on one of the names in the list it auto populates the other 24 txtboxes I have added to the form with the corrasponding info in that record... please help

Table name: Empdata
listbox name: Employee Name

Answer 1

The listbox will have events, like selected_item and item_change or lost_focus.

Pick one which works at the time you want, like lost_focus fires the event when the cursor moves to the next control or you click somewhere besides the listbox.

When the event happens, use the selected name to query your database and populate the other boxes