RE: Filter Datasheet based on Combo Box selection

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) & "#"
 
D

Daryl S

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) > & "#"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter query on combo box in a continuous subform 0
Combo Box Selection 1
getting a value in a table based on combo box selection in form 3
Need combo box to refresh when moving to new record 2017 1
Filter by Combobox, add ALL selection? 2
Trouble Filtering a Sub Form With Combo Box Options 2
Open a form based on combobox selection 5
Filter on combo box (Main Form and Sub Form) 6

Top