2 Search ombo Boxes on the Same Form

[Happy2]

Hi Everyone,

Please help me out. I need to have 2 combo boxes to search
on the same form. One searches by Manager and one searches by Agents. I use "ApplyFilter" for both combo boxes, but when I switch from one combo box to another, these combo boxes don't filter out the record that I need. For example, when I click on a manager, that manager doesn't show on the combo box.

Thanks in advance for your help.

 

[jdegeorge]

Are you trying to limit the choices in the 2nd combo box based on the selection of the 1st combo box?

Jim "Get it right the first time, that's the main thing..."

 

[Happy2]

Hi jdegeorge,

No, they are both independent combo boxes. Thanks for your prompt response!

 

[jdegeorge]

Do you have any code behind the form/combo boxes that you can paste here?

Jim "Get it right the first time, that's the main thing..."