Steve, this is just a SWAG, but does your Search Form open any tables? And if it does are the ALL opened with the "in 0" clause or with a "SELECT 0" command? You may be overwriting your Combo's SQL.

However I also agree with Erik - I only use cursors for my combos. The code is the same and they're a LOT easier to control.

HTH
Barbara

>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.