How to update a list box based on values selected in a combo box?

[SUHYB]

I need a code, expression, or a query that updates list box values based on
selected values in the combo box. For example, When choosing a country in the
combo box, the list box should list cities located in that selected country.

 

[Douglas J. Steele]

Use something similar to what's in
http://www.mvps.org/access/forms/frm0028.htm at "The Access Web".

Essentially, what you're doing is putting code in the AfterUpdate event of
the combobox to reset the recordsource of the listbox based on what was
selected in the combobox.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I need a code, expression, or a query that updates list box values based on
selected values in the combo box. For example, When choosing a country in the
combo box, the list box should list cities located in that selected

country.