Mixing 2 reports together

[evilcowstare via AccessMonster.com]

Hi ,
I have 2 seperate reports, one works off a drop down menu where you select a
client and it brings up all the jobs to the selected clients name. The 2nd is
a date report where you enter 2 dates and it brings up all the jobs between
them.
What I want to do is make them now work together, so 1st you select the
client then the dates and it brings up all the jobs for that client between
the dates selected.

The client report uses a "where" command, of client name=clientcombo for
example.

The date is written in code, now is there anywhere I can add a where command
or similar to the date code so that it filters the date results by the client
name on the combo...

The date code is ...

Private Sub OK_Click()
Dim strReport As String 'Name of report to open.
Dim strField As String 'Name of your date field.
Dim strWhere As String 'Where condition for OpenReport.
Const conDateFormat = "\#mm\/dd\/yyyy\#"

strReport = "DateReport"
strField = "DateJobReceived"

If IsNull(Me.txtStartDate) Then
If Not IsNull(Me.txtEndDate) Then 'End date, but no start.
strWhere = strField & " <= " & Format(Me.txtEndDate,
conDateFormat)
End If
Else
If IsNull(Me.txtEndDate) Then 'Start date, but no End.
strWhere = strField & " >= " & Format(Me.txtStartDate,
conDateFormat)
Else 'Both start and end dates.
strWhere = strField & " Between " & Format(Me.txtStartDate,
conDateFormat) _
& " And " & Format(Me.txtEndDate, conDateFormat)
End If
End If

Debug.Print strWhere 'For debugging purposes only.

DoCmd.OpenReport strReport, acViewPreview, , strWhere
End Sub

Thanks to anyone who helps )