RE: Filter Datasheet based on Combo Box selection

  • Thread starter Thread starter Daryl S
  • Start date Start date
D

Daryl S

Pasadena-D -

You can put your combobox in the header section of the subform. Then based
on the selection in the combobox, you can apply your filter like this (using
your fieldnames and combobox name). If the user will click on an item, you
can put this in the Click event of the combobox:

DoCmd.ApplyFilter , "[DateFieldName] = #" & Me.ComboboxName.Column(0) & "#"
 
Pasadena-D -

That is because the combo box is in the parent form instead of the subform.
You can put the combo box in the header of the subform instead of outside the
subform.

Otherwise you will need to set the Filter property of the subform like this
(instead of the DoCmd):

Me.subformName.Form.Filter = "[Pay_Period_Ending] = #" &
Me.Combo64.Column(1) > & "#"
 
Back
Top