Copy a record from Form

[Buj123]

Hello,
I have form for inputting data in to the table. Sometimes they need to enter same data with little changes.
so the user want a copy button on the form which will copy the last record and pastes it so that they can make changes where ever necessary.
How to do that?

 

[Buj123]

I got it. Use the Duplicate record of the command button wizard.

 

[mph1]

Look at the following:

http://www.mvps.org/access/forms/frm0012.htm

Word of CAUTION not sure of all the fields you have or purpose, but you many not want to carry forward all the data from each field to a new record. You may accidently save the same record twice with identical information.


HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[Buj123]

Thnk you for your response. Actually as i need to copy the whole record i have used the duplicate record, it worked out fine for me.
But the problem is when i do that its saving that OfficeClipBoard too, so then when i close the form its giving me a message saying "There is large amount of data in the clipboard and if you close this form it will be gone. Do u want to continue anyways?"

How to prevent this message from popping?

 

[formerTexan]

Try Docmd.SetWarning False on the form's close event. But no guarantees that it will apply to clipboard messages.

If it works, you will need to restore warnings on the form's open event. Docmd.SetWarnings True

Cheers,
Bill