You don't do an APPEND with a View. Could that have been your problem or were you just saying you needed to append a new record?

>I killed off the view the other day from the form, but it was still in the Report's DE. I had so many problems trying to get the view to update a NEW record, but it would not do the update, although everything looked good with the TableUpdate function. A simple change to the data was easily updated, but it would not update an APPEND. Anyway, I killed that view and went back to related tables in my form. I forgot that the Report had saved the DE. When I hacked into the REPORT FORM's table, I found three records still holding cursor info, so I deleted all three records. Luckily, I did no harm and the REPORT FORM opened up just fine. If I had kept the Local View, I'd have used REQUERY, as I had already put it into the Activate event to pick up the newly selected Customer info after leaving the Customer form. I wrote a simple SQL SELECT and saved the resulting data into a temporary cursor for the report form to use.
>
>All in all, I dropped the View and things have been much easier. I deleted three records in the REPORT FORM itself, and everything is running nicely once again.
>
>Cecil