>Hi all!
>
>Sometimes when I use a main form and then I open a new modal form to choose some data which was created by the select command and I want to refresh the data of the modal form with the selet command I receive this error message: Cannot access selected table.
>
>Anyone has an idea what is wrong?
>
>IVAN
I met this message when I forget to clen up rowsource for combo/list, i.e. if I have situation when Combo.Rowsource is cursor alias and I have to rebuilt the cursor (to get new recordset) I should firstly clean rowsource:
Thisform.Combo.Rowsource=""
Select ... Into Cursor cur1 && error will popup here if previous line missed
Thisform.Combo.Rowsource="cur1"
Edward Pikman
Independent Consultant