Variables Input to Table

[JimCowan]

Using Access/VBA 2000,
I want to push the value of a variable (varPayGrade)into a table (Salary_History), field (HPayGrade).
I have an open recordset, looks like this...

varPayGrade=10
Set rst = New ADODB.Recordset
rst.Open "Salary_History", CurrentProject.Connection
rst.Edit
Salary_History("HPayGrade&quot = varPayGrade
rst.Update
rst.Close
Set rst = Nothing

Not only can I not succeed to input, .Edit and .Update are also giving error messages. Thanks, anyone who can help me.

 

[Phathi]

Hi,

Try

[COLOR=red]
Set rst = New ADODB.Recordset
    rst.Open "Salary_History", CurrentProject.Connection,,adlockoptimistic
    rst.fields("HPayGrade") = varPayGrade
    rst.Update
    rst.Close
Set rst = Nothing
[\color]
[\code]

Ciao