By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,254 Members | 2,386 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,254 IT Pros & Developers. It's quick & easy.

Copy/paste fields in a form

P: 32
I have a MAINFORM with a Subform1 which has another subform2.

I want to copy the 'PORT_ID' field from subform2 and paste it to MAINFORM field called 'PORTA'.

I was thinking of having a button in subform2 which would copy and paste all at once.
May 15 '07 #1
Share this Question
Share on Google+
5 Replies


ADezii
Expert 5K+
P: 8,638
I have a MAINFORM with a Subform1 which has another subform2.

I want to copy the 'PORT_ID' field from subform2 and paste it to MAINFORM field called 'PORTA'.

I was thinking of having a button in subform2 which would copy and paste all at once.
To Reference the Field in the Sub-Sub-Form from the Main Form:
Expand|Select|Wrap|Line Numbers
  1. Me![PORTA] = Forms!MAINFORM!Subform1.Form!Subform2.Form![PORT_ID]
May 15 '07 #2

P: 32
Thank you for the reply!
Comand works exactly as expected when I add the button to the 'MAINFORM'.
But I would like the button placed in Subform2 and have it work the same way.
Possible?
May 15 '07 #3

ADezii
Expert 5K+
P: 8,638
Thank you for the reply!
Comand works exactly as expected when I add the button to the 'MAINFORM'.
But I would like the button placed in Subform2 and have it work the same way.
Possible?
Expand|Select|Wrap|Line Numbers
  1. Forms!MAINFORM![PORTA] = Me![PORT_ID]
  2.                 OR
  3. Me.Parent.Parent![PORTA] = Me![PORT_ID]
May 16 '07 #4

P: 32
Thanks works Great.
Now im working on Highlighting the entire record when clicking that same button.
May 16 '07 #5

ADezii
Expert 5K+
P: 8,638
Thanks works Great.
Now im working on Highlighting the entire record when clicking that same button.
Good for you! You won't be NewToAccess for long!
May 16 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.