Copy and Paste

[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

 

[Howard Brody]

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

 

[David T]

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
.

.