Populating a ListBox Based on the value of a ComboBox

  • Thread starter John Piotrowski
  • Start date
J

John Piotrowski

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
 
S

Sapphire

Could you please paste the query you have written?

Thanks

-----Original Message-----
I have an ADP that the users want changed. Right now
Click to expand...
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.
 

Ask a Question

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.

Ask a Question

Similar Threads

Passing values of listbox to other form's combobox 1
Populating a listbox from an excel column 2
Getting combobox/listbox data into a table 2
compare values between combobox and listbox 6
populate a combobox based on unique values in another workbook 16
Combo Box, List Box & a Sub Form 4
Converting an IDNum of a Combo or ListBox to its corresponding text for a TextBox 4
Filter report with Combobox AND Multiselect Listbox 2

Top