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@example.com
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
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 10, 2017 | The Computers & Internet
Dec 04, 2013 | Computers & Internet
Nov 04, 2013 | Games
May 12, 2017 | Compaq Visual Fortran Professional Edition...
May 14, 2009 | Microsoft Access 2003 for PC
May 01, 2008 | Microsoft Office Access 2003 (077-02871)...
Oct 28, 2007 | Computers & Internet
Oct 03, 2007 | Microsoft Office Standard for PC
101 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: