Update two tables

[Snurre]

I have a form which is populated from a selection query.
The query has data from two tables. When I am trying to
edit data in the form, I am told that the recordset is
not updateable.

How can I update two tables from a form, using a
selection query???

Best regards
Snurre

 

[Roger Carlson]

It depends on HOW you are using data from two tables. It's not the form
that's the problem, it's the query that is being used as the record source
for the form. In the Help system, you can find information about when a
query is non-updateable. The most common problem is not having a Unique
Index on one the JOIN field in one of the tables.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Ronny]

Hi..

Thank you, that solved it.. Setting Primary Key and no duplicates for both
joined fields...

snurre