>>Is there a way to trap the error "Cannot access the selected table" ?
>>I think I know the pint in code where it occurs, even closed what I thought was the offending open table, but it still persists.
>
>Do you use comboboxes bound to cursors and does the error occur on form closing?
>
>If this is the case you need to set the rowsource empty before the tables are closed.
>
>
>Agnes
I got it to work finally, I added thisform.mylistbox1.RowSource="" in the keypress ection of the form after exhausting all other places, especially textbox where the sql formed the rowsource.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."