Thanks!
I now use a simple "select query" I followed the video tutorial and found it worked fine using a combobox+listbox. So now I got it filtering the way I wanted it to.
The only problem now is when I select a row in the listbox it would update another field in the form with a primary key...
Hi, I am trying to get a listbox to update after I have run a query from a combobox.
The combo box "On Change [Event Procedure] looks like this...
Private Sub filtercombobox_Change()
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_typevenue"
DoCmd.SetWarnings True...