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
|
|||
|
|||
Form Subform DLookup
Team,
I have a Form / Subform (with tabs) On the Subform, I want to: 1. Sum values located on the Form to values located on the Subform. 2. Be able to add a new record for a subsequent Change Order. The latest attempt has been to display the sum is: Private Sub txt_Change_Order_Current_Agreement_Value_AfterUpda te() Me!txt_Change_Order_Current_Agreement_Value = DLookup("ZPCM_Agreement_Value", "ZPCM", "ZPCM_ID=" & Me!txt_ZPCM_ID) End Sub It appears that the sum and the adding of a new record are mutually exclusive. Is my assumption correct? --- Thanks for your time... John |
Thread Tools | |
Display Modes | |
|
|