Display a UserForm based on Data selected in another UserForm's ListBox

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!

Thanks very much for the input! It looks like it's about to do it's magic, but right when it gets to this block of code I get the following error:

"Could not get the List property. Invalid property array index."



Thanks again for the help!

On the first line of the "With" block:

frm.textbox1.text = .list(.listindex, 0)

Yes. And now, randomly without changing anything at all, I'm getting an error that says "Object Required" and it's highlighting the 2nd line of your code block "Set frm = New UserForm2" ...very strange...