Getting data from the latest Access record

[Shiry]

Hi everyone,
I need some help with MS Access.
I need to get information from a specific field in the latest record (to write it in some textbox), and then in a new record write some data to the same field.
I tried to get the last record by using "movelast" function and then, in the new record I opened I wrote the information.
but what accually happent is that the data I wanted to write in the new record was writen down both in the new record and the latest one (deleting previous data in that field).
I hope someone can help me.... I'm wasting a lot of time on this thing....
thanks, Shiry

[JPicasso_00]

Use movelast method to get to your last record...
then assing the data you want to transfer down into variables..
then use rs.AddNew method to make a new record.
rs will be pointing to the new record.
rs.fields("fieldname1") = variable1
rs.fields("fieldname2") = newvalue2
etc.
'

when done,
rs.update will add the new record to your database.



Hope this helps and
May the Force be with you.

[vchapran]

Do you use Data Bound Controls? If so, when you add a new record, you are leaving the last one and the last one gets update from Data Bound control.
Vlad