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?