Cntrl " VBA Code for Access Form

[MattRights]

Does anyone know the VBA code for the Control dito (cntrl + ") function in excel, access etc. This is the function that populates a blank field with a previous entry.

I currently have a form where I can use this method to populate fields via previously duplicated entries. However I would like to add a button to the form that provides the same function?

Please help.

 

[Banana]

Off the cuff, I believe if you set the control's property Default Vault to itself, it will do just that.