Ilona- What is in [ctrlnam] ? (What is the Control Source?) What is the data type of this field?
No, the "new" record isn't causing the problem - it doesn't become part of the recordset referenced by the Sum until something is typed in the row and the row is saved. Yes, using funky characters can be a problem, but brackets usually solve it. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Friday, November 11, 2005 5:27 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calcualtion error Hi John, Shahid emailed me his database and I had a good look at it. Forms and subforms are not one of my strong points but I experimented with his "problem". Basically he has a subtotal in the footer of the subform and this subtotal is to display in the main form, but it comes up with #Error. I have checked all the spelling and formatting and could not find any problem there. If I set the value of this field in the footer of the subform to a constant, it displays OK in the main form. If I set it to the value of the field it is supposed to sum, it shows the value of that field OK as I move up and down the rows in the sub form. But when I set it to =sum([ctrlnam]) the #Error displays in the main form. The only strange thing I noticed in his database is the object names. He uses "&" and "/" and "%" in field names. These should not normally cause a problem, but could they? Shahid has most names surrounded by square brackets, but I was just wondering if his object names could be causing a problem. I didn't try changing them, but that would be my next step. Another thing he doesn't do is check for possible division by zero done in other fields in the subform which are used to calculate the result of the field he wants to sum. The subform is in datasheet view and it shows the last record as the "new record" which ofcourse has zeros, spaces and nulls in it. Would that be affecting the sum() function? Also thank you very much for your responses to my queries. I will let you know how I go once I have tried them out. Thank you again for all your wonderful help. Ilona Adelaide, Australia -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of M.SHAHID QADRI Sent: Thursday, 10 November 2005 5:00 PM To: ms_access@yahoogroups.com Subject: Re: [ms_access] Calcualtion error Dear All I am attaching the database form in which I am facing the problem. Pls open the form named "Towel specs" Pls concentrate the filed highlighted with Color Red named (Pile to pile ) and Blue( named Yardage). When you change the value of red field it will reflect the impact on Blue field (as blue field works on formula). The problem what I am facing is that. In subform field named "Y pile" should change quickly by changing the value in red filed as it is just representing the blue field. But it is not happening I have to closed the form and reopen to get this change happened. I want a subtotal of filed Plbs/Dz in main form. For this I have used a field at form footer of subform by using sum command and have tried to show it on main form in the filed name d"Totla pile lbs/dz" but always an error message is coming. Hope I have explained my problem well. Will appreciate if you can attch file back by correction it Thanks Shahid Lonnie Johnson <[EMAIL PROTECTED]> wrote: Please post the formula of field A and exactly what you are trying to calculate in field B. qadri_ms <[EMAIL PROTECTED]> wrote:Dear All Pls adviced on my below problem I have cerated a main form name oredr in ahihc one filed named A is bening controlled by a formula and working well. In same form I have added a subform(in datasheet view) in which field A is being used for caucualtion in Filed B. The problem is that in the subform I want to have a sum of filed B and want to dispaly that sum on main form. I tried so many method but always finding an error message. Your help will be highly appreciated in this regards Besat regards shahid SPONSORED LINKS Database development software Database management software Database software Inventory database software Membership database software Microsoft access software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] SPONSORED LINKS Database development software Database management software Database software Inventory database software Membership database software Microsoft access software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Enjoy this Diwali with Y! India Click here [Non-text portions of this message have been removed] SPONSORED LINKS Database development software Database management software Database software Inventory database software Membership database software Microsoft access software ---------------------------------------------------------------------------- -- YAHOO! GROUPS LINKS a.. Visit your group "ms_access" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ---------------------------------------------------------------------------- -- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/