I have a form(form one) which calls a second form(form 2) that has a moverlist box using the moverlist box located in the gallery.

The last six lines of code a command click method on the first form look as follows.

If thisform.xxxx = 1
report form yyyy preview
else
do form two && this one contain the moverlist box
endif
close data


If form two code is invoked, Form two opens. The first thing "form two" requires is to select items from a moverlist box. In the load method of "form two", I open several table. Somehow while selecting items in the moverlist box the tables are closed and the program bombs. It seems the "close data"
command in "form one" is the culprit. If I comment out the "close data" in the click event of "form one", the tables remain open and the program works fine.

How is it that the moverlist box activates the "close data" commands in "form one"? I know the fix is the remove the close data in form one, but I was wondering why this happens?

Anyone have an explanation?


Thanks
Gaylen Jungling