I've been doing some looking and have found a number of topics that address my issue of joining 4 tables from an MS access db in VB6 but none work. I still get a "too few parameters, 1 expected" error. It's driving me crazy. I've put the latest code below but it still gives me that error. I feel I've been in a big circle.
Can anyone point out what I'm doing wrong?
P.S. I didn;t know how to go back and add to my previous question so I added a new one here.
strsql = "SELECT [Qualifications].*, [QualificationCourses].*, [Roster].*, [Arms].* "
strsql = strsql & " FROM ((( Qualifications "
strsql = strsql & " INNER JOIN QualificationCourses ON Qualifications.[CourseID] = QualificationCourses.[ID]) "
strsql = strsql & " INNER JOIN Roster on Qualifications.[AgentID] = Roster.[ID])"
strsql = strsql & " INNER JOIN Arms on Qualifications.[ArmsID] = Arms.[ID]) "
strsql = strsql & " WHERE [Qualifications].License = '" & Trim(userAdminMOD.currentUser.license) & "'"