Sorry it took so long to respond! I tried the following:
strSQLStmt = "SELECT rptSupportJobsExtendedOptions.*, tblSupport.FirstName, tblSupport.LastName" & _
"FROM tblSupport" & _
"INNER JOIN rptSupportJobsExtendedOptions" & _
"ON tblSupport.SupportID = rptSupportJobsExtendedOptions.Expr1" & _
"WHERE EXISTS ( SELECT *" & _
"FROM tblTickets T" & _
"INNER JOIN tblTicketAssignments A" & _
"ON T.TicketNumber = A.TicketID" & _
"WHERE T.TicketNumber = rptSupportJobsExtendedOptions.TicketNumber )" & _
"AND tblTicketAssignments.SupportID = " & [Forms]![frmReportParameterFormSupportDateOpenClose]![cboSupport].textvalue & ""
And got an error that said: Run-time error 438: Object doesn't support this property or method. When I debug, it highlights the query above.
Also, Expr1 is: @Expr1 VARCHAR(256)
That variable is passed through using a dynamically created pass-through query and the data is actually just a number. Should it be changed to INT?