Add record to form based on querry

[Guest]

Hello all. On my form based on a querry the add record button at the bottom
is greyed out. How do I make it so that I can add a record on the form and
for it to add to all of the tables on which the form is based?

Thank you
Greg Snidow

 

[Ed Robichaud]

As you have discovered, not all recordsets are editable. Try creating a
simpler query as the record source for you form. When data relationships
are correctly defined, (and cascade updates enabled) then all related tables
will be handled automatically.
-Ed