Thanks for your quick reply. John. But I still cannot solve my problem even I tried to set the Default datasessions to Private datasessions. Now I repost my problem here with some corrections, in fact, they are not databases but just 2 free tables. Hope John or anyone can help me, this problem worried me about for 2 weeks. :~~~~~

My question ---
I have a form that has a combo box. It has 1 column only and the rowsource is "first.code" where "first" is a free table's name. The rowsource type is 2-Alias. After I click one of the "code" in the combo box and then press the "Exit" button which I have a click event:

clear events
close tables
thisformset.release
use first
pack
use second
pack

Then it will have an error message "Cannot access the selected table", I know this error is due to the command "close tables".
If I did not click one of the code in the combo box and instead, I just type the code in, it will not have this problem. On the other hand, if I use the "second.code" as the rowsource instead of "first.code" and it will not generate this error message too. Can anyone help me to solve this problem or need me to tell you about it in more detail?

>When you did the "close tables" you disconnected the link between the combo and the "first" table. I would guess that you are using the Default datasession; in that case, any close tables in any form will affect all open forms with Default datasessions.
>
>
>>Dear all,
>> I have a form that has a combo box. It has 1 column only and the rowsource is "first.code" where "first" is a database's name. The rowsource type is 2-Alias. After I click one of the code in the combo box hide this form and open another form and then press the exit button which I have the click event:
>> clear events
>> close tables
>> thisformset.release
>> use first
>> pack
>> use second
>> pack
>>Then it will have an error message "Cannot access the selected table"
>>If I did not click one of the code in the combo box and instead, I just type the code in, it will not have problem. On the other hand, if I use the "second.code" as the rowsource and it will not generate this error message too. Can anyone help me to solve this problem or need me to tell you about it in more detail?
>>
>>Thanks
>>Power