join key of table Car_Model_Variants not in recordset

[Jon]

Query:
SELECT Car_Model.Manufacturer, Car_Model.Family_name,
Car_Model.Class_segment, Car_Model.Competes_Model, Car_Model.Popularity,
Car_Model_Variants.ModelYear, Car_Model_Variants.Variant_Name,
Car_Model_Variants.Power, Car_Model_Variants.[C:C], Car_Model_Variants.Options
FROM Car_Model INNER JOIN Car_Model_Variants ON Car_Model.Model_ID =
Car_Model_Variants.Model_ID;
While updating records within a table I am getting the following error:

join key of table Car_Model_Variants not in recordset

Any ideas?

 

[Jerry Whittle]

Check out the following towards the bottom under "Data is updatable under
certain conditions:"

http://support.microsoft.com/kb/304473

 

[Hans Up]

Query:
SELECT Car_Model.Manufacturer, Car_Model.Family_name,
Car_Model.Class_segment, Car_Model.Competes_Model, Car_Model.Popularity,
Car_Model_Variants.ModelYear, Car_Model_Variants.Variant_Name,
Car_Model_Variants.Power, Car_Model_Variants.[C:C], Car_Model_Variants.Options
FROM Car_Model INNER JOIN Car_Model_Variants ON Car_Model.Model_ID =
Car_Model_Variants.Model_ID;
While updating records within a table I am getting the following error:

join key of table Car_Model_Variants not in recordset

Your recordset does not include a field named Model_ID. If you want it
in the recordset, add it to the list of fields which follow the SELECT
keyword.

SELECT
m.Manufacturer
, m.Family_name
, m.Class_segment
, m.Competes_Model
, m.Popularity
, v.Model_ID
, v.ModelYear
, v.Variant_Name
, v.Power
, v.[C:C]
, v.Options
FROM
Car_Model AS m
INNER JOIN Car_Model_Variants AS v
ON m.Model_ID = v.Model_ID;

Are you intending to edit values for Model_ID in your form? That seems
like a bad idea, even if Access lets you do it. Re-consider whether you
even want to display Model_ID on your form.

Good luck,
Hans