Updating records using a form

[Guest]

I've created a form based on a 2 table query. When I open the form, I can
view all the records retrieved, but I'm unable to update or add new records
to the tables using the form. How can I add records using a form based on a
query?

 

[Dirk Goldgar]

I've created a form based on a 2 table query. When I open the form,
I can view all the records retrieved, but I'm unable to update or add
new records to the tables using the form. How can I add records
using a form based on a query?

It depends on the query. Most queries involving two joined tables are
updatable, but there are conditions that may render them non-updatable.
If you open the form's recordsource query directly, I'm guessing that
you'll find you can update that, either.

If you type "when can I update data from a query?" into the Access
help's search box, you should come (eventually) to a topic that will
help you indentify why your query is not updatable, and tell you what
you can do about it. If that fails, post the SQL of the query here, and
we may be able to see what's wrong.

 

[Guest]

You can go into the form properties (in design view double-click the box in
the top left hand corner). Go into the "Data" tab and change "Recordset Type"
to say "Dynaset (Inconsistent Updates)"