Filter by combo box nightmare

[ryonker]

Hi everyone and thanks for any help. I've searched through the forum for answers and have tried some that i have seen but still cannot get this to work.



I have a form to display records from one table. I need to be able to filter the records shown on the form by date. I've created a combo box that show the dates from the importDate field in the table and only unique dates. If I select a date from the combo box to filter the records nothing happens. I have the following code in the "afterupdate" of the combo box. The "importDate" is the field in the table that has the dates that the data was imported into the database and is the field that needs to be filtered on.

Private Sub cboImportDate_AfterUpdate()
Me.Filter = "importDate = " & Me.cboImportDate.Value
Me.FilterOn = True
End Sub

Any help would be greatly appreciated.

Thanks,
Robert

[jzwp11]

Date values must be enclosed by # signs. See if the following works:

Me.Filter = "importDate = #" & Me.cboImportDate.Value & "#"

Do you have the combo box in the header of the form and is the combo box unbound?

[ryonker]

This worked like a charm. Good to know about the dates needing # before and after and yes the combo box is in the header and is unbound. thank you so much for your help.

[jzwp11]

You're welcome. Glad that worked out for you.