I have a form which asks for a date with a button that executes another form which is supposed to show rows having the same date on it's date field.
I've created a On Open event in the form which is supposed to show the matchig rows with the following code:
Private Sub Form_Open(Cancel As Integer)
Me.Filter = DateValue([Forms]![Day]![customerfromdate]) = DateValue(fromtime)
Me.FilterOn = True
customerfromdate - is the date I enter on the first form ("Day" is the name of the form).
fromtime - is the date field on the table which I want to show only rows who's fromtime field equals to to the date entered in customerfromdate.
However, no records are shown when the Me.FilterOn = True.
Any help would be appreciated.