Combo box requery not correct

[But Hour]

I have two combo box in continuous form. In the Row Source of second combo
box , we got the parameter from the first combo box, and On After Update of
the first combo box we have code Me.SecondCombo.Requery.

When I select the first combo box then all records in this form becoming
display wrong data. How can I do?

But Hour, (Cambodia)

 

[Michel Walsh]

Hi,

It is because there is just one instance of a combo box for all the
records in the continuous view (if you compute the space requirement to hold
the list of each combo box, even limiting those seen on the form, you may
understand of the problem we may end up with in case there would be one list
per record per combo box). So, that behavior is "by design".


Hoping it may help,
Vanderghast, Access MVP