Tom,

Can you open the new view in the designer? Have you checked the DE of the form to make sure all of the cursors are what you think they are?

> I have not changed the structure of any of the tables since this view was created. I can requery the view when loaded (nodata) from the command window. The error only occurs when using the view within this form. this view was created by using the view designer to alter an existing view, and then saving it under a new name.