Urgent help writting vba

[Ian]

Hi,

I have a form open and i need to update a field on an
table that is not opened with the form.


table that needs updating is called "checkfile" the field
is call "updates" and the recordset is identified
as "CheckID"

Who do i write VBA to update as follows


updates = "2"

Many thanks for your help

Ian

 

[Ron Weiner]

Ian

The easiest way would be write a query that updates the table directly. If
I understood your post it would look like this.

DoCmd.RunSql "UPDATE checkfile SET updates = '2' WHERE CheckID = " &
YourRS.CheckID & ";"

Ron W