P
pokdbz
I have a report that needs to be opened with a SSN and a date. Here is what
I have so far:
SSN is the text box on the form where the user inputs the SSN
SpecificDate is the text box on the form where the user inputs the Date they
would like.
How do I open up the report using these to items.
Dim stDocName As String
stDocName = "SummaryReport"
Dim strWhere As String
strWhere = "SSN = '" & Me!SSN & "'"
strWhere = strWhere & " AND TodaysDate = #" & Format(Me.SpecificDate,
"mm/dd/yyyy") & "#"
DoCmd.openReport stDocName, acViewPreview, , strWhere
I have so far:
SSN is the text box on the form where the user inputs the SSN
SpecificDate is the text box on the form where the user inputs the Date they
would like.
How do I open up the report using these to items.
Dim stDocName As String
stDocName = "SummaryReport"
Dim strWhere As String
strWhere = "SSN = '" & Me!SSN & "'"
strWhere = strWhere & " AND TodaysDate = #" & Format(Me.SpecificDate,
"mm/dd/yyyy") & "#"
DoCmd.openReport stDocName, acViewPreview, , strWhere