Good day.
I have a form ("frmSchedule") with a subform ("subfrmSchedule" which is in datesheet view). The subform's record source is from "qrySchedule", where the date's control source is from "GameDate" (this is also the name of the control and is in text box type). The query lists many records with the same date. For example, some records has the date October 12, 2016, followed by some records having a date October 13, 2016, etc.
On the main form, I have an unbound combo box with its row source as "SELECT [qrySchedule].[GameDate] FROM qrySchedule;". The combo box also has an After Update event to filter the subform:
Private Sub Date_AfterUpdate()
If IsNull(Date) Then
DoCmd.ShowAllRecords
Else
DoCmd.ApplyFilter , "[GameDate] =" & Me.Date & ""
End If
End Sub
The issue is that the contents of the combo box lists multiple dates of the same date (following example):
October 12, 2016
October 12, 2016
October 12, 2016
October 12, 2016
October 13, 2016
October 13, 2016
etc.
How can I list the dates in my combo box to only show a date once? I tried using the date picker but was unsuccessful at it.
Thanks in advance.