Cannot not edit form

[stingray_69]

I have a form where I cannot edit the data on the form. It did work when I had it pulling data from one table but then I edit the sql statement to union in another table and not I can view the information by not make any changes. I am assuming this is because of the union statement. Is there any way to have the form allow edits with a union of two tables?

[pbaldy]

In a word, no. A UNION query will never be editable. If you didn't actually mean a UNION query, here are some general thoughts:

http://allenbrowne.com/ser-61.html

[stingray_69]

Thanks! I was afraid of that but I ll just add another table to my form instead of unioning the two tables together.

[pbaldy]

A UNION query is often a sign of an incorrectly designed database. Make sure your tables are properly normalized, and that you don't have tables for similar things, for instance a table for each year, product, etc.

Welcome to the site by the way!