How to duplicate values from one form to another?

The seven values (in unbound text boxes) on the footer of form "Root_H_P"  I want to duplicate in unbound textboxes on form "Annual Trend".

I have tried putting unbound textboxes on the "Annual Trend" with all types of formulas, but always get error mesaages.

See attached image for better description.
Duplicating-Values.jpg
cssc1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Eric ShermanAccountant/DeveloperCommented:
If both forms will always be open at the same time and these are not sub-forms ... Then set to Control Source of your Text Boxes on Form Annual Trend to something like .... Of course using your exact control names on Root_H_P.

= Forms!Root_H_P!TextControlNameHere

Do this for each of the seven controls using the correct control name.

ET
cssc1Author Commented:
Please see error
Error-101.png
Eric ShermanAccountant/DeveloperCommented:
Is [Human_H_T_frm] open??

ET
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Eric ShermanAccountant/DeveloperCommented:
Try this method ...

=[form name].Form![control name]

ET
cssc1Author Commented:
See error attached
error-3.jpg
Eric ShermanAccountant/DeveloperCommented:
Is [Human_H_T_frm] open??

 ET
cssc1Author Commented:
no
Eric ShermanAccountant/DeveloperCommented:
When you refer to a control on another form, that form must be open as well.

Also, are these sub-forms on a main form by any chance.  If so the syntax will be different.  

Let me know.

ET
PatHartmanCommented:
etsherman told you that BOTH forms needed to be open if you wanted to refer to controls on other than the currently active form.  Forms don't store data.  Tables store data.  It is only if a form is open and showing a record that you can refer to its controls AND you can only refer to the current record.

1. You should probably adopt some naming standards.  Having controls named Text218, Text 223, etc causes unnecessary brain strain and easily leads to errors as you have to look up the contents every time you need to reference a control.
2.  Since the controls are unbound, what is the problem with calculating them again?
cssc1Author Commented:
I don't have a problem calculating them again, however, I have two problems:

1. The form is not opened
2. I don't know how to write a quert expression the sums all TRUR check boxes for :1-Human Emgineering"
PatHartmanCommented:
I'll say it again.  Forms don't store data.  Tables store data.  To do the calculations again, you would need to use the same data source used by the original form.  

One possibility is to use a single form with tabs.  Then the calculated fields can sit on the main form and you can use the tab control to switch to viewing a different subform.

A query that counts yes/no fields  uses Sum() to add up all the 0 and -1 values and converts the negative result to a positive:
Select abs(Sum(YourField)) As TrueCount
From yourTable;

But - I'm going to guess that you mean "sum" in the sense of an Excel function because your table is not properly normalized.  That would be:

Select abs(Nz(chk1,0)) + abs(Nz(chk2,0)) + abs(Nz(chk3, 0)) + ....  As TrueCount
From YourTable;

Relational databases do not support functions that operate on ranges of columns as Excel does because that would imply the table contains a repeating group and repeating groups violate first normal form so data is normalized by moving the repeating group to a related table where each row is the equivalent of a single option.
Eric ShermanAccountant/DeveloperCommented:
Can you load up a sample of your db.  We can answer specific questions but I generally do not respond when I have to try and guess what the person asking the question is trying to accomplish.  Keep in mind we are not seeing what you are seeing.

Sounds pretty easy but I need to see exactly where you are now.

ET
cssc1Author Commented:
I have attached a zipped copy of the actual application

THe log on info is:

Name: Admin
Pass: Admin

To see the info of the I am trying to duplicate click the "Event Root" menu button, see bottom of form.
I am trying to duplicate it and put the information on the "Annual Trend" form. Click the Trend button on the main screen.
RC-Ver-96.zip
Eric ShermanAccountant/DeveloperCommented:
Ok, I will review and respond.

ET
Eric ShermanAccountant/DeveloperCommented:
Ok, I had a chance to review your sample db.  The totals or summary dats is on [Root Causes - frm] sub-form which is closed when you are opening the [Annual Trend] Form.   I duplicated [Root Causes - frm] -> [Root Causes2 - frm] which just the totals and made it an invisible sub-form on your main form such that the formulas are calculated and ready when form [Annual Trend] opens.  The control source for the seven controls are shown below.

Human  Eng  =[Forms]![Main_Menu]![Root Causes2 - frm].[Form]![Text187]
Training  =[Forms]![Main_Menu]![Root Causes2 - frm].[Form]![Text210]
Communications =[Forms]![Main_Menu]![Root Causes2 - frm].[Form]![Text221]
Management Systems =[Forms]![Main_Menu]![Root Causes2 - frm].[Form]![Text216]
Work Direction =[Forms]![Main_Menu]![Root Causes2 - frm].[Form]![Text200]
Procedures =[Forms]![Main_Menu]![Root Causes2 - frm].[Form]![Text195]
Quality Control =[Forms]![Main_Menu]![Root Causes2 - frm].[Form]![Text224]


See attached fixed db.

ET
C--Users-Eric-Downloads-RC-Ver-96-RC-Ver
cssc1Author Commented:
what program do I use to open this program?
Eric ShermanAccountant/DeveloperCommented:
It' just a zip file.  If you are using Windows just right click the file and select Extract All or use something like WinZip.

ET
Eric ShermanAccountant/DeveloperCommented:
Try this one ...

ET
RC-Ver-96-Fixed.zip
cssc1Author Commented:
THe file is unzopped, but it still asks me to choose a program.

see attached
Eric-File.jpg
Eric ShermanAccountant/DeveloperCommented:
Sorry, my original upload somehow got banged up ... never seen that before ...

Use this one ...

ET
RC-Ver-96-Fixed.zip

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eric ShermanAccountant/DeveloperCommented:
Can you explain why you are closing the question???  

I think you just wanted to accept my last post and award the points.

Thanks,

ET
cssc1Author Commented:
sorry, yes I was trying to close the question, thanks
cssc1Author Commented:
It fixed my problem
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.