Paste value from another form (1 Viewer)

[AnnPhil]

I would like to be able to double-click a value in one form and paste the value into a field of another form. What code would be needed to perform this?

 

[boblarson]

Will it be the same fields all of the time?

If so you can just set the value like

Forms!YourFormToPasteTo!FieldName = Me.YourControlNameHere

 

[AnnPhil]

Thanks so much it worked great!