Sally,
Then the tables/indexes/view would appear to be ok and not causing the error. What are you binding to the view? Individual controls or a grid? If it's a grid have you changed the view since the grid was created? Is the grid expecting a column that is no longer in the view?
>I can use the view in the command window fine but the only place the requery works is in the load of the form. Bombs anywhere else in the form. We even tried deleting the table the view is based on, recreating it, and rebuilding the view. No luck. We are using the View Designer.