Syntax Error:
You are missing the first table name FROM tblName1
strSQL = "SELECT txtLicenseType,dtIssueDate, dtExpiryDate,txtLicenseNo FROM tblName 1 INNER JOIN tblPropertyLicense ON " & _
"tblLicense.IntLicenseID = tblPropertyLicense.IntLicenseID WHERE tblPropertyLicense.IntFileID = " & intId
Thanks,