I'm sure there has to be a way to do this, but I'm drawing a blank. I need to open a table, but if there's any problems, I don't want that open file dialog to come up. I just want it to return a value so I can deal with it silently.

I keep coming back to ON ERROR, but I don't want to have a seperate program to handle the error. Can I do it all in one program? Like have ON ERROR at the top and call a sub program in the same program file? And if I do that, how do I pass the information back to the line that had the error?

I'm trying to get something like:

IF open_table("mytable")
  ...
ELSE
  ...
ENDIF

Thanks,

Michelle