Add record to form based on querry

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

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

"Greg Snidow" wrote in message
...
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