Changing available selection in a combo based on other combo box

[Epsilon101]

As an example, If you had a several queues, each holding accounts.

Can have 2 filters on a form one to select any of the accounts and one to select any of the queues.

Then if you dont want to filter by the queue you can still choose any of the accounts listed.

What i want to try and do is when you select a queue, the other combo box only lets you choose from accounts in that queue and no other.

What may make this harder is, i need to have the ability to filter on several queues all selected from the one combo box.

This will effectively stop people from choosing a queue and account that dont match, then the report the filter goes on will always show some info.

---------------------------------------
Any help would be great!

 

[glalsop]

You could have a look at faq702-4289 for a technique to create cascading combo boxes.

What may make this harder is, i need to have the ability to filter on several queues all selected from the one combo box.

If it gets to this point, you will probably want to look into a multi-select list box as the control for your queue field. Filtering your second combo box based on the selections in the multi-select list box is certainly possible, but is a bit more difficult than creating cascading combo boxes.


-Gary

 

[Epsilon101]

Thanks for the faq link ill test that out

---------------------------------------
Any help would be great!

 

[deBassMan]

May I suggest using a SQL statement for the second combo based on the selection from the first combo - works for me!