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

Sum textbox from Subform on Mainform

P: 2
Hello Afternoon!

I've been trying to work out whats going wrong with my function for the last 2 days. I give up...

I have a main form (Infinity) with a command button which pops up a subform (Nominated) when clicked. The 2 forms are linked by a field called "Application ID".

The subform records the individual cash amount each employee has been rewarded - and this limits which employees appear based on the Application ID...

For example :
Application ID is 123 and in the subform it displays all the employees and each individual cash amount if the Application ID is the same.

I have set up a textbox in the footer of the subform to give a total for each Application ID. I have called this CTLtotal in the Name area within Properties. In the control source area the calculation which totals the cash amount is =SUM([Voucher Amount]). This appears to work just fine.

When I try and create a textbox in the main form to pull through the sum amount I keep getting Name#?

Its driving me insane. Any help would be absolutely FANTASTIC. I'm not a developer, I'm just very persistant and will not let this beat me (with your help :-) )
Apr 15 '10 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,770
It sounds like you may need Referring to Items on a Sub-Form.

Alternatively, I'm not absolutely convinced you actually mean sub-form rather than another simple form that is opened by code in your main form. This would be quite a different situation.

If the link doesn't help try posting the code you're referring to (that opens the sub-form) and we'll see what we can do to help.
Apr 15 '10 #2

Post your reply

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