|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 2nd, 2004, 06:31 PM
|
|||
|
|||
Subform to main form calculation
I can't get the data in my subform to calculate in my main form. Here's my
formula =Sum(TradeInfo.Form!AmountofGain) Any ideas? Thanks in advance, Tony 
|
|
#2
July 2nd, 2004, 08:08 PM
|
|||
|
|||
|
Subform to main form calculation
Tony,
If I understand you correctly, I think you need to put an unbound textbox in the Form Footer section of the subform, with Control Source set to =Sum([AmountOfGain]) then name this textbox, let's say it is TotalGain and then the Control Source expression in the main form textbox will be =[TradeInfo]![TotalGain] -- Steve Schapel, Microsoft Access MVP Tony wrote: I can't get the data in my subform to calculate in my main form. Here's my formula =Sum(TradeInfo.Form!AmountofGain) Any ideas? Thanks in advance, Tony
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
| Filter subform combobox on option button in main form | Emma | Using Forms | 1 | June 12th, 2004 12:24 AM |
| Filter subform combobox on option button in main form | Emma | Using Forms | 2 | June 11th, 2004 10:29 PM |
| Subform not open - but it is on open main form??? | Paula | Using Forms | 1 | June 7th, 2004 05:32 PM |
| Controls on Main form affecting subform? | Will | Setting Up & Running Reports | 1 | May 27th, 2004 07:37 PM |
Linear Mode
