populate excel userform from access database

Hi all,

I have an access database where I collect all the old emails. Now I need to use a excel userform to show them in a form that looks similar to outlook.
I have the text fields where the data will be displayed.

I can make a connection to the access database and populate a sheet with the info there, but how do I to populate the text fields for 1 record per time?
I also have a listbox that shows all the emails that are in the database (subject of the email). How can I populate a list box from a colimn called Subject in access to the listbox called ListSubject in the userform?

Hope some one can help.

Greetings.

I passed the whole thing to access database itself.