>When using rowsourcetype 3 (SQL), doesn't that leave myTable open as long as the form class is in use? I'd like to keep myTable close whenever possible so that the table is not tied up (just in case I need to make modification to the table that requires exclusive on). Or am I worrying about something that is nothing?

Hi Inge,

The table myTable will be open by select every time cursor is created: on combobox instaniation and on each requery(). However, combobox itself works of cursor select creates and doesn't requere myTable to stay open.