G
Guest
I'm working on a continuous form, with a query as the record source. I
assigned an event for a combo box named [Combodate], I wanted this combo box
to filter the form's date field based on the selection made. I placed this
combo box on the Header and used a Getfocus and ApplyFilter macro where the
event for the combo box is:
Afterupdate, Get Focus : [DateA]
Applyfilter, Where Condition: ([DateA]=[ComboDate])
But this setting kept popping out an "Enter parameter value - combodate"
box - which I have to type in the date value even though I selected it from
the combo
already.....it does filter this way but it beats the purpose of the combo box.
It seems like the macro could'nt find the [comboDate] in the form..because
even if I rename or place the combo box in the details section, the dialogue
box keeps popping out.
assigned an event for a combo box named [Combodate], I wanted this combo box
to filter the form's date field based on the selection made. I placed this
combo box on the Header and used a Getfocus and ApplyFilter macro where the
event for the combo box is:
Afterupdate, Get Focus : [DateA]
Applyfilter, Where Condition: ([DateA]=[ComboDate])
But this setting kept popping out an "Enter parameter value - combodate"
box - which I have to type in the date value even though I selected it from
the combo
already.....it does filter this way but it beats the purpose of the combo box.
It seems like the macro could'nt find the [comboDate] in the form..because
even if I rename or place the combo box in the details section, the dialogue
box keeps popping out.