Question about Microsoft Office Standard for PC
I have a hard problem linking the above subject. The main forms as Customers with sub-forms of CustomersOrder & CustomersPayment. I have created 3 txt boxes to accomodated; TotalPayment, TotalOrders & Current Balance with the ff: property control source of the ff: TextBox Name: txtTotalPayments Control Source: =Nz([sbfPayments].[Form]![txtPayments]) Format: Currency TextBox Name: txtTotalOrders Control Source: =Nz([sbfCustOrders].[Form]![txtItemsTotal]) Format: Currency TextBox Name: txtCurrentBalance Control Source: =Nz([sbfCustOrders].[Form]![txtItemsTotal]) - Nz([sbfPayments].[Form]![txtPayments]) Format: Currency And the return value is "#Name?" Please help me figure it out? Thanks. Raul L. Cadosales [email protected]
Hi Raul from your description it is very unclear what you are trying to do. First we need to know what information is on the first form, second unless you are trying to do a subtotal of all orders in the subform there is no real need for you to create a subform. Now if you are trying to create a subtotal form for all records, you will have to set it up in the record source of that subform with group by: 1. Right click on an empty space on the subform 2. Click on properties 3. Choose your table(or query) which is the record source of the main form. 4. Select Payment and items(or what ever you are trying to calculate). 5. Press the group by button 6. In totals instead of group by choose sum. 7. Exit and save 8. Now when you will select the control source you will see "sumofpayment" etc... just select them for each textbox. 9. To create the third text box you will have to use the Expression builder and just do [textbox1]-[textbox2] * for some reason the nz function does not work in this case. I hope that helped you I will be able to give you a better answer if you give me more details... Let me know what happend Good luck Daniel
Posted on Sep 06, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Apr 05, 2013 | Sony Playstation 3 (PS3) Console
Nov 01, 2010 | 3Com 4500 24-Port Ethernet Switch
May 14, 2009 | Microsoft Access 2003 for PC
Mar 12, 2009 | Canon Digital Rebel / EOS-300D Digital...
Sep 05, 2008 | Magic Sing Along Consumer Microphone
Jul 16, 2008 | Microsoft Office Professional 2007 Full...
Oct 28, 2007 | Computers & Internet
Oct 03, 2007 | Microsoft Office Standard for PC
Aug 16, 2007 | Microsoft Office Standard for PC
105 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: