>Bingo.. As I remove my combo box.
>There Is No Error Message!!!
>
>However, After I re-write the combo box'rowsoure..
>e.g ThisForm.cmbPayment.rowsource ="payment.code,name"
>
>It prompt another error ' Alias "payment" cannot find'
>It seems. close all the tables !! How can restore it ???
>
>Thanks In Advance.
Agnes,
If you do not have good reason to have RowsourceType as fields use SQL instead. It would open tables as necessary and tables would be closed upon form closure since it's a private datasession. ie:
with thisform.mycombo
.Rowsourcetype =3
.Rowsource = 'select code,name from payment into cursor crsPayment'
endwith
Cetin