Unedittable query

[Exsubsailor]

water.zip

I am using combo boxes with lookup tables in my forms V_DETAILS AND H_DETAILS. When I make the source for the forms the tables of the same names (no query), I am able to edit/input data. If I change the source of the forms to the Queries of the same names (two related tables), I cannot edit through the forms. If I run the queries separately, I also can't edit the data. What am I missing?

[JoeM]

It sounds like you have queries which are not updateable.
Can you post the SQL code of your queries (I am unable to download anything from my current location).

BTW, here is a listing of reasons why queries may not be updateable:
http://allenbrowne.com/ser-61.html
See if your query falls into any of those categories.

[Exsubsailor]

SELECT V_DETAILS.V_TYPE, Points.*
FROM Points RIGHT JOIN V_DETAILS ON Points.PNO = V_DETAILS.PNO;

[JoeM]

Do both of your tables have primary keys?
What kind of relationship exists between the two tables (one-to-one, one-to-many, many-to-many)?

The Right Join could be playing a role here.
If you change it to an Inner Join, does it become updateable (I know that may not be what you eventually want to do, but try it out and see what happens)?

[Exsubsailor]

inner join has no effect, the problems remains. Yes there is a primary key (ID) in each table but that is not the related fields.

[JoeM]

So, what kind of relationship exists between the two tables when you JOIN on the PNO fields?
Many-to-Many relationships create queries that are not updateable.

[Exsubsailor]

SOLVED....it was that neither of the fields in my joined tables were unique values. thanks for the guiding light!

[JoeM]

SOLVED....it was that neither of the fields in my joined tables were unique values. thanks for the guiding light!

Yep, that would cause a many-to-many relationship.