Linking results from Mulitple Combo Boxes...

[supplyside]

By selecting values from mulitple Combo Box, I want to narrow down the results that reflect all values selected.

Thank you.

 

[Darrylles]

Hi,

OK

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[Darrylles]

Hi,

You can't be bothered with an explanation, I can't be bothered with a solution.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[uscitizen]

perhaps this is another way of expressing my thread, i.e., i have a combo box on a form (which populates a field on the underlying table) with three possible choices, i.e. 'IRB', 'CCI' and 'N/A' which stands for the usual 'not applicable'. When the user chooses either of the first two (IRB or CCI) i would like the adjacent field/control on the form two show a drop down list of dates which the user must choose one from that are relevant to the choice he's just made (CCI or IRB). there are only eignt possible dates which comprise the dates available under either choice.i would imagine that a table with two columns, one with the value CCI or IRB, the other having a date in it and i've created it with the 16 rows worth of information, sorted by the character field. what's the next logical step, assuming right thinking so far?

thanks for any help?

 

[supplyside]

I need some assistance regarding combo boxes. For my example I would like to be able to sort on four different kinds of data with the selections being captured by hitting a submit button. After a user made their selections, I want only the records that the meet the values selected in the combo boxes.