Dale,
Unfortunately, you cannot use the error handler to trap for this situation. You have to check if the file exists before trying to use it.
There was a discussion about here:
How to avoid the open table window popup ? Thread #
787904 Message #
787904>I have a form where we just added a free table to the DE. The problem is we have an ON ERROR handler that does not get fired when the table can not be found. A locate for dialog comes up. Does anyone know how I can trap for that?
>
>Thanks,
>Dale
Steve Gibson