the query of the listbox uses the combo box a filter BUT you must refresh the listbox when the combo changes.
the listbox query is : qsList1Device
select * from table where [device] = forms!myForm!cboBox
then in the cbo box AFTERUPDATE event, refresh the listbox
Code:
sub cboBox_afterupdate()
listbox.requery
end sub
BUT if you want to see ALL items in the list box with a null cbo box, you need 2 queries:
Code:
sub cboBox_afterupdate()
if isnull(cboBox) then
listbox.rowsource = "qsAll"
else
listbox.rowsource = "qsList1Device"
endif
end sub