copy paste from one form to another

blade12568

New member
Local time
Today, 07:13
Joined
May 6, 2002
Messages
7
hello ive kinda asked this question a while ago but still cant get it to work the way someone said to try so im looking for another way or bit more detail in how to do the other way mentioned
(just search for my username to see hte other post)

i want to copy 2 fields from one form to another using a command button

the text boxes are unbound on the form thats having the info pasted theother boxes are bound from the other form

hope u follow me a to what im trying to do

thanx for any help
 
Both forms must be open. In the click event of the button put:

Me.UnboundFld1 = Forms!OtherFormName!Fld1
Me.UnboundFld2 = Forms!OtherFormName!Fld2

Reasons that this might not be working for you,
1. The other form is a subform in which case the syntax would be - Forms!OtherMainForm!OtherSubForm.Form!Fld1
2. The other form is a continuous form or datasheet and no current record is selected.
 

Users who are viewing this thread

Back
Top Bottom