Error in cascaded combo box

[Guest]

Hi! I have a form that is driving me insane--I have two combo boxes which I
finally got working correctly (thanks to this group), but now I am getting
"Field cannot be updated" error message on the first box when I try to select
an item from the list.
Here are the details...

The first combo box is based on a table of Manufacturers. The second box is
based on a query which contains Models from those Manufacturers. So, when
you select a Manufacturer, the cboModel updates to list only those Models
from the selected Manufacturer. That seems to work properly, until I add
other fields to the form, and that's when I get "Field cannot be updated"
error message. The fields are not locked, and the whole point of the
cascaded fields are for entering new records to an underlying table (this
particular form is not for adding any new records to the Manufacturers or
Models, however--I just need to be able to select them and use them to
identify the rest of the record).

Thanks for any help!

 

[Wayne Morgan]

The "field cannot be updated" will be caused by trying to update a field
that is a calculated field or perhaps trying to make a change to a record
based on a query that isn't an updatable query.

The combo boxes won't try to update the tables they pull data from unless
you try typing new data into them. If all you do is select items that are
already in the combo boxes, the only thing they will attempt to update is
the form's recordset if you have placed a value in the Control Source
property of the combo boxes. If you have, the value from the Bound Column of
the combo boxes will be placed in the field listed in the Control Source.

 

[Guest]

Wayne,

Thank you for your help. My problem was a query that was not updatable.
I've restructured my table and queries and I think it's working properly. I
really appreciate your help!