>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.
>
The simple answer to this is to not use the SQL statement as a rowsource. Use Cursor, and run a SELECT INTO CURSOR in the form load. This is better for a few reasons- the SQL is easier to edit, and you control exactly when to requery the cursor.
Erik Moore
Clientelligence