Either use a saved query as the listbox's rowsource, and have the query
look up the combo for its criterion, like:
Forms![TheFormName]![TheComboName]
and requery the listbox every time the combo changes, or use some simple
code in the combo's Change event like:
strRS = "SELECT FiedX FROM MyTable WHERE FieldY = " & Me.ComboName
Me.ListboxName.Recordsource = strRS
In the above sample code I have assumed the combo / FieldY to be
numeric; if text, then:
strRS = "SELECT FiedX FROM MyTable WHERE FieldY = '" & Me.ComboName & "'"
While the article refers to a set of cascaded ComboBoxes, the same technique
can be use on a ListBox whose RowSource is dependent on the value selected
in a ComboBox.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
