>>Is there a way to trap the error "Cannot access the selected table" ?
>>I think I know the point in code where it occurs, even closed what I thought was the offending open table, but it still persists.
>
>Do you use SQL statement as the RecordSource? Do you have a different comboBox with the same RecordSource on the form? Sometimes when you have SELECT... INTO CURSOR C1 in the RecordSource of two different objects on the form you will get "Cannot access ... " error.
I was wondering where have you been? Nice to have you back.
If it's not broken, fix it until it is.
My Blog