possible to update 2 fields in VBA qry (1 Viewer)

[BennyLinton]

Is it possible to update two different fields within the below UPDATE code?

With CurrentDb.CreateQueryDef("", "UPDATE Applicants set Applicants.Emailed = -1 WHERE Applicants.[GCDF No] = @1")
.Parameters(0) = rs(0)
.Execute
End With

 

[Ranman256]

yes. put the sql with all the updates.
you dont even need sql, use queries.