I don't think he wants the error handler to open the table...he wants it to catch the error, without the user seeing the "Open" dialog. Perhaps it is for a server program, where there is not a user?
>I cannot understand why you want the error handler to open the table for you if it is not open when you issue the select statement? How will the error handler know which table to open?
>
Steve Gibson