Updating using a Data Environement

[Himmer]

Any one know of a way to update a recordset/database using a
data environment? The only possible way I can see, is to
use the ADO or DAO control. Which dosent make any sense
sense. When I coding it, for example I type

DataEnvironement1.rscomTest.Update

VB auto fills in the .Update for me, which tells me there
must be a way to do it...

Anyone ?

Thanks in advance

[simonm]

You need something like this:


With DataEnvironment1.rscomTest
!Field1 = <Value>
!Field2 = <Value>
.
.
.Update
End With


Assign the new values to the fields first then call the update method.

The .Update attempts to commit the changes to the recordset and changes the edit mode to 'adEditNone'.