Union Query Form

[rkmaitra]

Hello,
I have a continuous form for which I have just changed the data source to be a UNION query. Previously, the control source for the form was one of my databases - now the control source should be the database from which the particular record was derived.
Unfortunately, I find that I am not able to modify any of my records after creating the union query for the data source - I have checked that none of the fields are 'locked' and all are 'enabled'. I assume this is because I have 2 databases as my record source. Is there any way around this?
Thanks,
Rudra

 

[Galaxiom]

Union queries are not updateable.
You probably need to restructure the data.

BTW the Form has a Record Source. Control Source is a property of controls.