Copying Last Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple database with the following fields:

strID (AutoNumber) "Primary Key"
strDate
strLineNo
strStartTime
strEndTime
strCode

There a several records that I need to duplicate and was wondering how I can
duplicate a whole record.
 
This question should have been posted in another News Group (perhaps
mpa.Queries).

You can use an append query. Otherwise, you can copy a record and paste
append it.
 
Actually, I'm not looking to use an append query. The person doing the data
entry has very little knowledge of Access. What I want to do is possibly
creating a button which will copy and paste the previous record entered
without the data entry person having to close the data entry form completely.
 
Back
Top