Avatar of MTMonday
MTMonday
Flag for United States of America asked on

How do I duplicate the values of multiple fields for all new records based on the unbound text box that have been filled?

I am using Access 2007.  I have a form with 2 parts:  The form header consists of unbound textboxes and a Duplicate Fields Flag Option button.  If the textboxes are filled (they could all be filled or some) and if the duplicate fields flag option is yes, then I want the text in the unbound boxes to be filled in the bound text boxes in the detail section.  Then I want the cursor to move to the (Detail section in the form) to the Pounds field.  At that poin the data entry person will update the pounds field, BFat, Prot, OS and SCC and take them to a new record.  Again the value from the duplicate Fields should be filled in the new record. I have tried some code, but does not seem to work.  I cannot seem to get to the new record.
KeyesPunch-DB---Copy.accdb
Microsoft AccessMicrosoft Development

Avatar of undefined
Last Comment
MTMonday

8/22/2022 - Mon
SOLUTION
Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Hamed Nasr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
MTMonday

ASKER
ended up using both solutions with my own modifications!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck