Add record to form based on querry

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top