Updating a recordet - repost

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

I am still having problems with the following:

I have 10 fields in a datasheet sub form, if a particular
criteria is met 5 of those fields are added to a table
(tableB), using the recordset and the Addnew method.

If the value of one of the 5 fields changes I would like
to have it change in tableB. I have tried using the
recordset and the Edit method but it is adding another
record to tableB.

I've defined the recordset used

..edit
..fields("Field1") = newValue
..fields("field1") = newValue
..update

however it is updating the incorrect record.

Any suggestions?
 
You have to use the find or seek method to place the record pointer on the
specific record then you can use the EDIT method. Check the help file for
FIND or SEEK.

Cheers,
Henry
 
Back
Top