How to update the recordset supported by view

[sanford101]

I populate a recordset with a view which consists of a union
everything goes well except when I update the recordset.

I got a error message "unable to update a riew with a union.". AnyBody has any solve the Problem?

Thanks a lot for any Tips

[Serge]

If you have a Union query undelying the recordset, then you can't update the recordset. Also, the same goes to a recordset that has joined tables in SQL statement.
Just think about it. Using Union, you combine more then one Select statement (possibly more then 1 table), now, how the database would know which table you want to update? The solution would be either write an update SQL statement that will update the table or create a recordset that is updatatable.