Displaying a record for editing and saving

[John C]

I have a form with some text boxes and check boxes.

It allows the user to reflect current status of plant
equipment for 'turnover' to the next shift.

When the form is opened, I am using:
DoCmd.GoToRecord , , acLast
to retrieve the last record entered (which should be the
most current).

The problem I seem to have is that the data is being
changed, but not saved as a new record (for later
retrieval if needed).

How do I display the latest record for editing without
changing the old information, then save it as a new record?

Thankyou in advance...

 

[GVaught]

The last record in the table is not always the last entered. This depends on
what you use for a primary key in the table. This determines the sorting
sequence. If you an autonumber it may work for awhile, but keep in mind a
autonumber field can go negative. What I would do is create a field in your
table called timestamp and then set the default to Now(), which will return
the current date and time a records was entered. From this entry you can
then find out what record was the last one entered.