error 3061 too few parameters, expected 5? (1 Viewer)

[Bigmo2u]

Here is the code:

With db
                               
    .Execute "INSERT INTO tblCurrentLocation (SerialNumberID, SiteLocationID, ZoneID, SectionID, RowID, BayID, clDate, clTime) " & _
             "VALUES('" & ssn & "', sli, zid, sid, rid, bid, #" & cld & "#, #" & clt & "#)"

End With

there are more than 5 parameters, I was having issues before thei with the date fields.

form that is passing these variables are set to what they are suppose to be on the form.

 

[pbaldy]

There are 5 values (variables?) not concatenated into the string as the others are.

 

[Bigmo2u]

okay, I kind of get what you ar elooking at. I have 5 number fields, 1 string and 2 date/time fields. So what am I doing wrong?

 

[pbaldy]

All of the values need to be concatenated into the string. You have correctly surrounded date values with #, the text value with '. Numeric values don't need a delimiter, but still need to be concatenated.

"VALUES('" & ssn & "', " & sli & ",..."

 

[Bigmo2u]

Okay, thank you so much pbaldy.

 

[pbaldy]

No problem; post back if you get stuck.