Data Type MisMatch

[Eranka]

HI

Lid1 = Me.Text78 'ID (Not Enabled & Locked)
Lid2 = Me.Text62 'Passport_Number
Lid3 = Me.Text15 'Student_ID (Not Enabled & Locked)

CurrentDb.Execute "Update Alumni_List SET [Surname] = '" & Me.Text5 & "' WHERE [ID]= '" & Lid1 & "' AND [Passport/Number]= '" & Lid2 & "' AND [Student_ID]= '" & Lid3 & "'"

When i execute the above code, i get Datatype mismatch error. Please advice me what is wrong here?

[June7]

I presume ID and Student_ID are number fields. Do not use apostrophe delimiters with number type.

Why would you need all 3 criteria? Can a student have multiple passport numbers? Why would you save Surname to Alumni_List and not just Student_ID? Why even have a separate table for alumni?

[Eranka]

Hey

Student ID contains letters as well.

CurrentDb.Execute "Update Alumni_List SET [Surname] = '" & Me.Text5 & "' WHERE [ID]= Lid1 AND [Passport/NIC_Number]= '" & Lid2 & "' AND [Student_ID]= '" & Lid3 & "'"

i changed the code as above, but i still get the error "Too Few Parameters, Expected 1"

[June7]

You are not concatenating Lid1 variable.

CurrentDb.Execute "Update Alumni_List SET [Surname] = '" & Me.Text5 & "' WHERE [ID]= " & Lid1 & " AND [Passport/Number]= '" & Lid2 & "' AND [Student_ID]= '" & Lid3 & "'"

[Minty]

As advised here - https://www.accessforums.net/showthread.php?t=78631
You will save yourself time if you get into the habit of building the SQL expression into string and debug.print it - your error would have been more obvious.