I have three forms. I hope this will end up being a handy wizard for me.

Form1 is a tablename lookup using getfile()
Form2 will be a field name click selection
Form3 will be the main processing form

I have changed the variables from Public to Private

I added the suggested code to form 2 in the load method

I then tried your code DO FORM Page2 WITH TableName under the 'Next' button, which calls form2, and I am getting a "variable TABLENAME is not found" error. So, I added the & to TableName and got a sytax error. I changed it back to your original code line and continue to get the error.