UPDATE query: too few parameters

[mocitaisa]

I'm trying to update a field in a table named tblPeople from data contained in a field on a form. The following is what I have but it keeps telling me I have too few parameters, can anyone help?

Dim CurDb As Database
    Dim SQL As String
 
 
    Set CurDb = DBEngine.Workspaces(0).Databases(0)
    SQL = "UPDATE tblPeople SET password = Forms!frmUserChangePass!NewPass WHERE tblPeople.[PEOPLE_ID]=[Forms]![frmLogin]![id_list]"
    CurDb.Execute (SQL)
    CurDb.Close

[Scott Price]

You asked a question in a tutorial on the Access Articles page. This breaks several rules of common sense! Number one is that very few people are likely to see the question in order to answer it!

I have split your question into a separate question and moved the thread into the Access Forum, where our Experts will be more likely to see it and answer it.

Please avoid posting your question in another persons thread in future.

MODERATOR

[Scott Price]

SQL = "UPDATE tblPeople SET [password] =" & Forms!frmUserChangePass!NewPass & "WHERE tblPeople.[PEOPLE_ID] =" & [Forms]![frmLogin]![id_list] & ";"

Try something along these lines.

Regards,
Scott