Here's my problem. I have a form with a combobox on it which has a RowSourceType = SQL SELECT Statement and RowSource = The SQL SELECT statement itself. When I run the form the I have in the Form Load Event:
USE lookup in 0 SHARED to open the lookup table for the SQL SELECT in my combobox. That works fine.

But when I go my Search Form and come back to that combobox form with SQL SELECT statement. I get "Cannot access selected table" error. I can't figure out where to put the USE lookup command so my table is open when I return to the form with the combobox on it. I tried putting it in the Find button where I return after running the Search Form, but no help.

Any ideas where I can place the USE command? I know it's got something to do with my combobox RowSource SELECT lookup because the whole combobox disappears after I get the error. I tried putting the USE lookup command in the combobox Init, but no help also.

Thanks for the help.