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

 

[Uncle Gizmo]

I answered a post a while back about duplicating records in a sub-form. I gather that you want to duplicate records on the main form, so this might only be a curiosity for you.

If it's of Interest you can download it here:- https://gum.co/SubRecDuplicator for a limited time by using the coupon code:- freetodayonly

For more information about this method and way it was developed see my blog on Nifty Access here:-

Subform Record Duplicator - Nifty Access

Subform Record Duplicator Nifty Access - "Subform Record Replicator" allows you to provide your user with the facility to quickly add sets of duplicate records in a subform. All they need do is specify the number of Records they want to add, select a record to copy, and hey presto you've got a...

www.niftyaccess.com