Hi,

I would like to write a VBA code that could with double-click copy value from selected field in a form to another form.

For example, in the PopUp form named “frmGLO” in column “Refer2” I would like that double-click would copy value ("AR2A") to another opened form EntryHead in the field “Refer1”

Please see the picture below.

How can i make that?


ReferCopy.jpg