this RecordSet is not updateable - using form to update table

[davyre]

Hi, I got this checkbox in a form to mark the status of the item. The control source has been linked to the corresponding table.
When I update manually from the table (i.e opening the table and then click the checkbox in the field STATUS, I can simply update the status of each record there). But when I'm using the form to update the STATUS field, the status bar shows message "the recordset is not updateable". Why is that? Anyone can help? Thanks

 

[PHV]

What is the SQL code of the RecordSource of the form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[davyre]

How can I check that? I was using form wizard to create the form, so I did not write any code in that form except for close form button.

 

[PHV]

Is the form based on a query or the table ?
What is the value of the AllowEdits property of the form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[davyre]

I made a query that has similar field selection on the form:

SELECT TblOrderUnit.OrderID, TblOrderUnit.UnitID, TblOrderUnit.ETD, TblUnits.UnitDescription, TblOrderUnit.UnitDeliveryDate, TblUnitPart.PartID, TblUnitPart.Qty, TblUnitPart.DeliveryStatus, TblParts.VendorID
FROM (TblUnits INNER JOIN (TblParts INNER JOIN TblUnitPart ON TblParts.[PartID] = TblUnitPart.[PartID]) ON TblUnits.[UnitID] = TblUnitPart.[UnitID]) INNER JOIN TblOrderUnit ON TblUnits.[UnitID] = TblOrderUnit.[UnitID];

is there something wrong? When I tried to update the query in datasheet view, it also shows the same message "This recordset is not updateable".
How can I check the value of AllowEdits property of the form?

 

[PHV]

Be sure to select the PrimaryKey of each table in your query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

Multiple-Table Queries are frequently Read-Only. Allen Browne has an excellent article on the whys and wherefores:

Why is my query read-only?

The Missinglinq

Richmond, Virginia

The Devil's in the Details!