Deplicate selected values in Forms

[sadiq92]

Hello,

as you know when adding buttons on forms you can add many “ ready-make” buttons including duplicate record button. However, the duplicate button will duplicate all the values from the last record.

Is there a way I make the duplication occur only for selected fields and make the other fields empty???!!!

 

[arnelgp]

if the record shown in form/table is the Duplicated record, not in New record,
you can just blank out the fields you don't want to be duplicated:

'code after running duplicate record
...
...
' blank out some fields
Me!Field1 = Null
Me!FieldX = Null
' save changes
Me.Dirty = False

 

[sadiq92]

if the record shown in form/table is the Duplicated record, not in New record,
you can just blank out the fields you don't want to be duplicated:

'code after running duplicate record
...
...
' blank out some fields
Me!Field1 = Null
Me!FieldX = Null
' save changes
Me.Dirty = False

where I put this code?

 

[arnelgp]

inside the code of your "ready-made" button (duplicate record).