Thank you in advance for your help.
I am printing a report using VBA. I need to specify 2 criteria for the report to select what I want to print.
I created the syntax the way I thought it should work but I am getting a type mismatch error.
[Property Address 1] is a text field and [DAte Placed] is a date field
Below is my syntax.
Dim strLinkCriteria As String
Dim stDocName as String
stDocName = "Result Letter"
strLinkCriteria = "[Property Address 1] =" & "'" & Me![Property Address 1] & "'" And "[Date Placed] =" & "'" & Me.[Date Placed] & "'"
DoCmd.OpenReport stDocName, acViewPreview, , strLinkCriteria
Many thanks for your help