Click to See Complete Forum and Search --> : Edit recordset


laucha
November 6th, 2000, 10:52 AM
Hi there:

I extract a recorset that has 10 records and 5 fields
I can edit all the records in the recordset at once using a Grid.
I modify them by editing the contents of the grid cells.

Which is the best way of modifying the data in the underlying table?

Should I use rs.edit .......... rs.update to modify all the records in the
recordset? Are there any other methods? I´m using DAO 3.6.

Thanks

Johnny101
November 6th, 2000, 11:01 AM
If this grid is bound to a data control, the changes are already saved in the tables as soon as the user moves off the edited row.

john

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org