Urgent help writting vba

  • Thread starter Thread starter Ian
  • Start date Start date
I

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
 
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
 
Back
Top