Too few Parameters Error

[jasdem]

I am trying to run this query in the back end. The information that is selected through this query is used to generate emails further on. When I go to generate the emails, I get the Run-time error 3601

 strQuery_Appointment = "SELECT TableALOA.CFN, TableLocation_ALOA.Location, TableLocation_ALOA.Date_Location, TableLocation_ALOA.FieldCaptain, TableLocation_ALOA.Address_1, TableLocation_ALOA.Address_2, TableLocation_ALOA.Room, TableALOA.Appointment, TableALOA.DBN " & _
                            "FROM TableLocation_ALOA INNER JOIN (TableALOA INNER JOIN TableSchools ON TableALOA.ID_Schools = TableSchools.ID) ON TableLocation_ALOA.ID = TableALOA.Location " & _
                            "WHERE (((TableALOA.CFN)='" & rcdNetwork!CFN & "') AND ((TableLocation_ALOA.Location)='" & rcdLocation!Location & "')) " & _
                            "ORDER BY TableALOA.Appointment, TableALOA.DBN;"


    Set rcdAppointment = CurrentDb.OpenRecordset(strQuery_Appointment, dbOpenDynaset)

Set rcdAppointment is highlighted in the error message.

[Dal Jeanis]

Generally that's going to mean that rcdNetwork!CFN or rcdLocation!Location is NULL. In your case, however, you have them in quotes anyway in the SQL, so that's not it.

I aliased the query to make it easier to read. The resulting code made me wonder if there is really a field TableLocation_ALOA.Location (TL.Location), or if your WHERE clause should actually read TableLocation_ALOA.Location (TA.Location)

strQuery_Appointment = "SELECT " & _ 
   "TA.CFN, TL.Location, TL.Date_Location, TL.FieldCaptain, " & _ 
   "TL.Address_1, TL.Address_2, TL.Room, TA.Appointment, TA.DBN " & _
   "FROM TableLocation_ALOA AS TL INNER JOIN " & _ 
      "(TableALOA AS TA INNER JOIN TableSchools AS TS" & _ 
      " ON TA.ID_Schools = TS.ID) " & _ 
   "ON TL.ID = TA.Location " & _
   "WHERE (((TA.CFN)='" & rcdNetwork!CFN & "') " & _ 
   "AND ((TL.Location)='" & rcdLocation!Location & "')) " & _
                            "ORDER BY TA.Appointment, TA.DBN;"