View Single Post
  #1  
Old June 7th, 2010, 05:15 PM posted to microsoft.public.access.forms
John
external usenet poster
 
Posts: 2,649
Default 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