Edit/Add in Queries

[bightme_99]

I created a query that selects records from more than one table. Then I created a form with the aformentioned query as the recordsource. Now Access won't let me edit any of the data in the form. I can't add records, or change what's already there. I assume that this is because the query pulls from multiple tables.

Is there a workaround?

 

[Pat Hartman]

Queries that include joins are usually updateable unless you have done something wrong. Look up updateable queries in help for more information. But the following are some reasons:

1. One or more of the tables uses an aggregate function.
2. The tables are not properly joined.
3. You don't have update permission for one or more of the tables.
4. If the tables are linked, both of them must have unique indexes. (You can create psuedo indexes in Access if need be).

 

[bightme_99]

Thanks. That really helped a lot.