Combo box requery not correct

  • Thread starter Thread starter But Hour
  • Start date Start date
B

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)
 
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
 
Back
Top