I have a VB4 form which has a data control (whose record source is a
recordset of type Dynaset, created by a query via ODBC to an Oracle database)
and a number of bound text boxes.

I have implemented an Insert button which does an AddNew and a Save button
which amongst other actions does an UpdateRecord.

After performing the UpdateRecord I would like the current (displayed)
record to be that just inserted. I have tried a number of things
but have not got a satisfactory solution - currently I do a Refresh
of the data control followed by a MoveLast.

This is ok when the table is ordered by an auto-incrementing numeric key but
otherwise does not work.

Any ideas would be greatly appreciated.  

Thanks in anticipation

Andy Gurd

March Systems Ltd

BazInOz

Regards,
Srini.

Private Sub cmdAdd_Click()
  Data1.Recordset.AddNew
End Sub

Private Sub cmdSave_Click()
  Data1.UpdateRecord
  Data1.Recordset.Bookmark = Data1.Recordset.LastModified
End Sub

Hope this is what you need. I'll be hounest and tell you I don't have a
clear understanding of what the Bookmark is all about, but I tested this
code with and without it and with it the inserted record remains the
current record.  Without it, it did NOT remain the current record.

By the way, this code was generated by the Data Form Designer.  You can
learn a lot by using that feature of VB 4.0 Prof if you have it. :-)

as far as I know will new records be added to the _END_ of the dynaset,
they won't be sorted until you recreate the dynaset with the
Refresh-Method.
At least this is true for VB3.0 pro/Jet 2.0.
When the new record is written to the database with the
Update[Record]-Method, the pointer will return to the one which was
current before AddNew.
Performing a MoveLast will return you to the last added record. So if you
leave out the Refresh, it should work.

Hope it helps

Thomas

*****
If you are well, don't worry ... it will pass over.
*****