ComboBoxes on Continuous Forms

[Jacob JKW]

It seems that when I create an unbound ComboBox on a continuous form
the ComboBoxes displayed on each record share all the same properties.
When a user changing the value (selected record) in one of the combo
boxes the values in all of them change. Is there any way to for Access
to treat each ComboBox separately so that changing the value of one box
won't affect the values in any of the others?

(A bit of background: I'd like changing any one of the box's values to
fire a AfterUpdate which then updates the displayed values in other
combo boxes on *that record only*. Is this even possible with a
continuous form? I have no problem doing it on a columnar form but on a
continuos any time any instance of the ComboBox box is changed, every
record's ComboBox RowSource also changes.

 

[tina]

Is there any way to for Access

to treat each ComboBox separately so that changing the value of one box
won't affect the values in any of the others?

not as long as the control is unbound.

hth

 

[Jacob JKW]

Is there any way to for Access to treat each ComboBox

not as long as the control is unbound.

Thanks for the response. Guess I'll just have to use a single form. :-(