Update a table from a Recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a recordset from an existing table and I need to update the data in
the table based on some checks that I have done against the recordset.
Basically, I have certain criteria the data needs to meet or I have to make
updates based on conditions.

I want to do this without having to create another table for the updates. Is
this possible?
 
It is possible...I did it by directly opening the table using the
Openrecordset("tblname") and then doing my checks and updating the data in
the table using .edit and .update at the key points of the conditions.
 
Back
Top