>I want as this time to return control to the form/cancel processing if there is
> an error otherwise continue. what should i do i get a prompt to ' open table in database' i don't want this prompt

There's not alot you can do. VFP doesn't let you trap this, as far as I can see. Simply find out where the error occurs, and why (because a tables not open of course), then try to fix it.