Thank you ADezii and missingling for your replies. It has worked perfectly.

I am trying to populate data into a listbox using VBA from a popup form.

The main form holds the listbox and the button that opens the second form. I want the user to be able to enter an address into the second form. When the user clicks the close button on the second form, I want to add the data into a new row in the mainforms listbox without writing the data to a table at this stage (this is done later on the collection of other...