passing listbox rowsource to another form's listbox

[roosn]

hi, i have a few questions on using a popup form

1. on my main form, i have a listbox, i would like to edit the values of the listbox.

to do this, i have a popup form with 2 listboxes, one to have the values of the listbox on the main form, and the other listbox with option values for the 1st

hence seeking guidance on

1) how to i pass the rowsource sql of the listbox on the main form to the listbox on the popup form

2) how on closing the popup form, do i update the rowsource sql listbox on the main form from the changed value of the popup form listbox rowsource sql

many thanks

 

[llkhoutx]

sub FormPopUpname_ON=n OPen()
me.listbox2.rowsource = forms!mainformname.listbox1.rowsource
end sub

 

[roosn]

thanks, thats very helpful today

however, it leads me to another problem

when i save and close the popup form, can i reload the formatting of the active form, which would normally occur when that form loads

i have the list box heights set to the listcount etc

 

[llkhoutx]

On the popup OnClose event, reset the main form.

Note that I don't know what you mean by the following:

...reload the formatting of the active form.