Unanswered: Running a macro based on combo box value
I want to have a combo box on a form that when a value is selected a macro is ran that opens a filtered form based on the value I select.
For instance say the combo box contains colours and I select Red. I want this to then open a form with all the records filtered down to Red results.
The macro I have currently to filter is the OpenForm action against the form I wish to open with the Where Condition field set to [Colours]="Red". I want to somehow replace Red with a variable that is linked to whatever I choose in the combo box?
How do I do that? Anyone know??
If this is not easy or there is any other easier way please can you suggest this?
My problem seeems to be related to this thread except instead of filtering I want to open particular forms based on a user's selection from a combo box. Am I just being dense and missing something obvious?
Thanks in advance for any help.