Hi all,

I have a macro that returns a list of records from an Access database and displays each of these records in a listbox on one of my UserForms.

I'm wondering - is there any way for me to display a separate UserForm with text boxes that are populated with data according to which specific record is selected in the listbox from the first UserForm?

Example: The ListBox displays a list of students returned from an Access database, showing StudentID, LastName, FirstName, Address for columns in the listbox. If I click on the record that shows data for John Doe, (ID# 123, Address 123 Cranberry Lane) I want to display a separate UserForm that has 4 text boxes (one for each attribute) and populate them according to John Doe's data. (ID, Last Name, First Name, and Address fields would be populated appropriately).

Thanks again all for the help!