Filter from Combo Box Value List

  • Thread starter Thread starter travs0626
  • Start date Start date
T

travs0626

I am trying to filter records matching value from combo box selection.
Structure is so:
Form - Header contains 3 unbound combo boxes all with Value Lists
Form - Detail contain fields from small table
I want to allow user to select first combo box value and filter the records
by one field based on the value they select, then from that filtered records
list select combo box two and filter again by another field and same with
three. Not sure this is possible or if Macro is best way to accomplish this.
Macro for first combo box is:
Action Arguments
SetTempVar ActiveControlValue, [Screen].[ActiveControl]
ApplyFilter (Where) = "[Vendor]="
&[TempVars]![ActiveControlValue]
RemoveTempVar ActiveControlValue
[Vendor] is the first field on Form that I am filtering by. When I select a
value from the combo box I recieve the popup to "Enter Parameter Value"
Any help is appreciated. Thanks.
 
Travs,

I don't think using the TempVar is the best approach. Just use the
SetValue action in your macro, and set the Where Condition argument to
the equivalent of this:
[Vendor]=[Forms]![NameOfYourForm]![NameOfYourCombobox]
 
Back
Top