Cannot update UNION query, object read-only

[mcdhappy80]

I have a union query as record source of the DAO record set that I try to update but I'm getting this error message. Can I solve this somehow?

Thank You

 

[vbaInet]

Just like the error message says, You cannot update a Union Query

 

[mcdhappy80]

[SOLVED]Cannot update UNION query, object read-only

Just like the error message says, You cannot update a Union Query

Thnx. Just wanted to check.

 

[vbaInet]

No worries mcdhappy80

 

[gemma-the-husky]

you can update the underlying records with vba, though

 

[mcdhappy80]

you can update the underlying records with vba, though

How, I tried and I couldn't?