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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New record not showing up on form 4
Open form on current record 2
Querry link to Report 4
How to count consecutive records base on 2 groupings 0
querry's and subforms 1
Querry Criteria 3
how to autorun access everytime runs the database 2
Querry does not allow to add records 1

Back
Top