>>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
It is a situation as you describe, but my table is still open, and issuing
thisform.mylistbox1.RowSource=" "
does not help matters.
"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."