Copy and Paste

  • Thread starter Thread starter David T
  • Start date Start date
D

David T

Please help.

I have a form (frm1) open. The user then clicks on a
command button which opens another form (frm2), leaving
frm1 open behind. The user then has 3 drop down menus to
click. When they choose the three options, there is a
text box txt2 that records their selections. How can I
copy and paste the selection in txt2 on frm2 back into
another text box (txt1) on frm1.

Hope this makes sense.

Thanks
David
 
Use the SetValue action in a macro

Item [Forms]![frm1]![txt1]
Expression [Forms]![frm2]![txt2]

Or, with code

[Forms]![frm1]![txt1] = [Forms]![frm2]![txt2]

Hope this helps!

Howard Brody
 
Cheers Howard, seems so bloody simple now.

Thanks again
-----Original Message-----
Use the SetValue action in a macro

Item [Forms]![frm1]![txt1]
Expression [Forms]![frm2]![txt2]

Or, with code

[Forms]![frm1]![txt1] = [Forms]![frm2]![txt2]

Hope this helps!

Howard Brody


-----Original Message-----
Please help.

I have a form (frm1) open. The user then clicks on a
command button which opens another form (frm2), leaving
frm1 open behind. The user then has 3 drop down menus to
click. When they choose the three options, there is a
text box txt2 that records their selections. How can I
copy and paste the selection in txt2 on frm2 back into
another text box (txt1) on frm1.

Hope this makes sense.

Thanks
David
.
Click to expand...
.
Click to expand...
 
Back
Top