Changing Values from a form based on a union query

[Guest]

I have created four separate input forms for sales reps to enter information
for an admin person. I want to keep the forms (and the tables associated
with them separate). Each of these individual forms is based on a query such
as LetterRequestJoeQuery which is then based on the table LetterRequestJoe. I
then created a union query that combines all four individual queries and then
a form based on this union query. The idea was to give an admin person a
view of all entries and to be able to edit them. But I have discovered that
you cannot change the information on a form based on a union query. Can
anyone suggest an alternative way of doing this?

Thanks,

 

[Allen Browne]

There is no way to may a UNION query updatable.

You *really* need to redesign these table, so there is not a separate table
for each rep. The combined table will have an extra field identifying which
rep the record is for. You can *very* easily get something that looks like
your existing table, just by using a filter with criteria that limits it to
one rep.