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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05