Continous Form Payments Issue (1 Viewer)

Weekleyba

Registered User.
Local time
Today, 08:02
Joined
Oct 10, 2013
Messages
586
Attached is my database and the F_Contract will come up when opened.
I'm trying to put the Payments section together on the tab "Payments".
I keep getting an error in my SSF_Payments and I can't figure out why.
Can anyone take a look and point me in the right direction?
 

Attachments

  • 0 DFM 9 payment issue.zip
    331.2 KB · Views: 55

Weekleyba

Registered User.
Local time
Today, 08:02
Joined
Oct 10, 2013
Messages
586
Looks like I made an error in the txtPaymentsMade calculated textbox.
Did realize how important the " " are around the DSum parameters.
Corrected expression for txtPaymentsMade:

=DSum("[PaymentPerLineItem]","[Q_PaymentPerLineItem]","[ContractLineItemID]=[Forms]![F_Contract]![SF_Payment]![SSF_Payment]![ContractLineItemID]")
 

June7

AWF VIP
Local time
Today, 05:02
Joined
Mar 9, 2014
Messages
5,425
So issue resolved?
 

Weekleyba

Registered User.
Local time
Today, 08:02
Joined
Oct 10, 2013
Messages
586
Yep. Not sure how to mark it solved with this new web format??
 

Users who are viewing this thread

Top Bottom