requery issue when combo box values set by another combo box value

[pubdude2003 via AccessMonster.com]

I am experiencing a problem when assigning values from one combo box to
another. When I want to clear the newly assigned values I simply requery the
combo box (single form so no issues there) but it refuses to requery. The
orginal values for the combo are set when the form opens. Should the requery
not ask for the original rowsource set by the control properties for the
combo box or does it just requery based on the new rowsource assigned by the
other combo box|?

 

[Steve]

Your second combobox gets its values from a query that has the value of the
first combobox as a criteria in one of the fields of the query. If you don't
change the value of the first combobox, you will always get the same set of
selections in the second combobox.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Perhaps you could clarify. Are you saying that the values in combo box 2 do
not update when you change the value in combo box 1? If so you simply need to
put the following in the after update event of the 1st combo box;

me.combobox2.requery ("combobox2" being whatever the name of you 2nd combo
box is)