Hi, I have a main form which has a button that brings up a small pop up form to enter dates from and to. I then want the subform on the main to be filtered according to these dates. So far I have, where frmSummary is the sub.
Forms!frmMain!frmSummary.Form.Filter = "Date_game" & " Between " & Format(Me.txtDateFrom, conDateFormat) _
& " And " & Format(Me.txtDateTo, conDateFormat)
Forms!frmMain!frmSummary.Form.FilterOn = True
but am getting an error on frmSummary.Can anyone spot where I am going wrong? Thanks!
Forms!frmMain!frmSummary.Form.Filter = "Date_game" & " Between " & Format(Me.txtDateFrom, conDateFormat) _
& " And " & Format(Me.txtDateTo, conDateFormat)
Forms!frmMain!frmSummary.Form.FilterOn = True
but am getting an error on frmSummary.Can anyone spot where I am going wrong? Thanks!