my form is called ClientDataForm, it displays basic personal info, it has a subform displaying in datasheet view called HoursWorkedSubform, which records the date, activity and times of each offender. on the "ClientDataForm" there is a combobox called 'OffenseRecord_Combobox" is has unbound variables inside it, "First Sentence", "Second Sentence" And "Third Sentence", what i have so far is, when either First, Second or Third Sentence is selected in the combo box, a corresponding start and end date is made visible, by an If else staement
"Private Sub OffenseRecord_Combobox_AfterUpdate()

If OffenseRecord_Combobox = "First Sentence" Then
   Me!FirstSentenceHours.Visible = True
   Me!FirstSentenceStart.Visible = True
   Me!FirstSentenceFinished.Visible = True
   Me!SecondSentenceHours.Visible = False
   Me!SecondSentenceStart.Visible = False
   Me!SecondSentenceFinished.Visible = False
   Me!ThirdSentenceHours.Visible = False
   Me!ThirdSentenceStart.Visible = False
   Me!ThirdSentenceFinished.Visible = False
ElseIf OffenseRecord_Combobox = "Second Sentence" Then
   Me!FirstSentenceHours.Visible = False
   Me!FirstSentenceStart.Visible = False
   Me!FirstSentenceFinished.Visible = False
   Me!SecondSentenceHours.Visible = True
   Me!SecondSentenceStart.Visible = True
   Me!SecondSentenceFinished.Visible = True
   Me!ThirdSentenceHours.Visible = False
   Me!ThirdSentenceStart.Visible = False
   Me!ThirdSentenceFinished.Visible = False
ElseIf OffenseRecord_Combobox = "Third Sentence" Then
   Me!FirstSentenceHours.Visible = False
   Me!FirstSentenceStart.Visible = False
   Me!FirstSentenceFinished.Visible = False
   Me!SecondSentenceHours.Visible = False
   Me!SecondSentenceStart.Visible = False
   Me!SecondSentenceFinished.Visible = False
   Me!ThirdSentenceHours.Visible = True
   Me!ThirdSentenceStart.Visible = True
   Me!ThirdSentenceFinished.Visible = True
Else
   Me!FirstSentenceHours.Visible = False
   Me!FirstSentenceStart.Visible = False
   Me!FirstSentenceFinished.Visible = False
   Me!SecondSentenceHours.Visible = False
   Me!SecondSentenceStart.Visible = False
   Me!SecondSentenceFinished.Visible = False
   Me!ThirdSentenceHours.Visible = False
   Me!ThirdSentenceStart.Visible = False
   Me!ThirdSentenceFinished.Visible = False
End If"
   
End Sub, beneath the combobox for each corresponding sentence,FirstSentenceStart and FirstSentenceFinish etc, Data for that is stored in the same table as the data in the main form. what i want now is when a sentence is selected, i want the Subform to Display the dates found between the Start and end date of a selected sentence in a field called Date of Attendance.

---

Answer from Richard Rost:

I would do it by changing the RecordSource property of the subform to an SQL statement, like this:

SubFormName.RecordSource = "SELECT * FROM TableName WHERE myDate >= #" & StartDate & "# AND myDate <= #" & EndDate & "#"

Adjust accordingly, of course. I cover this in my Access 311 course:

http://www.599cd.com/site/courselist/access/access311/?key=BlFAlEx