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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a tmp table from recordset 9
Control a Query Datasheet with Code 2
Recordset code problem 5
unbound form returns values to table 2
adOpenStatic Recordset still changing my table 5
Update recordset without affecting table records 1
How to connect to a BE database? 0
Deleting Records from recordset 9

Back
Top