Dropdown value automatic update upon selection

[HansBades]

I have two columns of comboboxes side by side. The second column value depends on the corresponding value of the combobox in the first row. Off to the right, I have a combobox that shows all the values together that are displayed individually side by side in the first and second column. When a user changes a corresponding value in the second column, the underlying table value doesn't update. If the user then clicks the combobox that shows all the values, it still doesn't show the update. The user has click on another combobox in the first two columns before the update will take effect. I have tried many event procedures to get the underlying value to update immediately upon a change in the second column combobox value but nothing is working. Any ideas what I can do? Thanks.

[Micron]

If these controls are bound to fields, then they don't update until you leave them - and the record doesn't update until you leave the record. In that case, maybe requery the form, but that will put you back onto the first record if this is a datasheet or continuous form. If that's a bother, you'd get the bookmark property of the current record, requery, then make the current record equal to the bookmark value.

If your table is open and you choose a value and then moving off the field or record and activate the table window again, chances are you need to refresh the table from the ribbon. Switching to the table window often does not refresh the view, so you might think the new value isn't in the table, but it is.

[June7]

Normally, the only value that should be saved from either combobox is a record ID. If you want to display related data in other textboxes, that can be done but should not be saving to record.

Cascading combobox is a common topic. Implementation for data entry can be a bit frustrating.

If you want to provide db for analysis, follow instructions at bottom of my post.