"Field cannot be updated" Error Msg

[Ice007]

Hi!
Having problems with updating an Item field in a form's subform. The Item field is a combo box with just 6 choices. When I try to add a new record and use the combo box, I receive the error message. All my relationships seem to be okay. Your suggestions would be much appreciated. Attachment included. Thanks!

 

[missinglinq]

Many of the people who help out here are still running 2003 or earlier versions of Access and cannot run accdb files, so when attaching one it would probably be a good idea to save your app as an mdb file.

But a few general questions:

1. What is the RowSourceType/RowSource for this Combobox?
2. What is the Item field Datatype? Is it Text, like it sounds?
3. Can you enter data into any other Control on the Subform?
4. Can you enter data into any Control on the Main form?
   

Linq ;0)>

 

[Ice007]

Thanks for the quick reply! I'll also attach a .mdb file to the original post.

What is the RowSourceType/RowSource for this Combobox?
Table
SELECT [Inventory].[ITEM] FROM Inventory ORDER BY [ITEM];
What is the Item field Datatype? Is it Text, like it sounds?
Text
Can you enter data into any other Control on the Subform?
Item combo box is the first column on the subform, after choosing
an item, error msg pops up
Can you enter data into any Control on the Main form?
Yes (when entering a new customer's information)

 

[missinglinq]

Can you enter data into any other Control on the Subform?

Item combo box is the first column on the subform, after choosing an item, error msg pops up

That answer doesn't address the question! Ignore the first column and try to enter data in another Control on the Subform, and tell us what happens. There's always the possibility that your entire Subform is Read-Only.

Also, your original post still only shows the accdb file as being attached; there's no mdb file.

Linq ;0)>

 

[Ice007]

In the subform, yes I can update other controls (ie, quantity, price and a total calculation is performed but when I go this route and press the combo box and choose an item, nothing happens (item field left blank).

I tried saving my .accdb to .mdb but get this message:
You cannot save this db in an earlier version format because it uses features that require the current file format.

Thanks!