Copying Last Record

M

Mooney88

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.
 
D

Duane Hookom

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.
 
M

Mooney88

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.
 
Top