Duplicate Record without Changing Textbox

[alyon]

Is it possible to duplicate a record, and stop the default value of one textbox changing to the duplicate record's textbox value?
For example:


Permit Number:
Name:
Address:
copy the name and address but not the permit number.

[alyon]

I got it, incase anyone else is wondering how to go about it,
Create a command button with this code:
Dim txtInspection As Integer
txtInspection = Me.txtInspection

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend

Me.txtInspection = DMax("[Inspection #]", "[Enter Inspection]") + 1

Exit_CopyRecord:
Exit Sub


**txtInspection is the textbox you don't want to be copied.
**Enter Inspection is your table name.