Populating a ListBox Based on the value of a ComboBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an ADP that the users want changed. Right now the form in question has a combobox and a listbox. The listbox is populated with client names. The combobox lets the user select what fiscal year they wish to view. They want me to change the listbox to only show clients that have done work with them during the selected fiscal year. This was easy using an MDB but now I can't get it to work. I understand I probably need to use a parameter query to populate the listbox but I'm not sure how to go about it. Any help would be greatly appreciated.

John
 
Could you please paste the query you have written?

Thanks

-----Original Message-----
I have an ADP that the users want changed. Right now
the form in question has a combobox and a listbox. The
listbox is populated with client names. The combobox
lets the user select what fiscal year they wish to view.
They want me to change the listbox to only show clients
that have done work with them during the selected fiscal
year. This was easy using an MDB but now I can't get it
to work. I understand I probably need to use a parameter
query to populate the listbox but I'm not sure how to go
about it. Any help would be greatly appreciated.
 
Back
Top