coolcatkelso
Registered User.
- Local time
- Today, 21:42
- Joined
- Jan 5, 2009
- Messages
- 279
Hiya
Access 07
I have this invoice form, with some info on like Order Total, Payments, Sales Tax etc just what youd expect on an invoice,
In the Payments (Unbound) I have this code
=IIf(IsNull([WorkorderID]),0,DSum("[PaymentAmount]","Payments","[WorkorderID]=" & [WorkorderID]))
Default value is 0.00
However, if I have just created a new workorder, then nothing shows in the "payments" field, unless I goto my other form "make Payment" and delect the Amount to be paid and put a 0 in
Any help?
All other calculations work perfect, and the reason I need this to work is I have a report that shows un-paid accounts, and if there is nothing in the payment field, it shows it as being unpaid
Cheers
CCK
________
Penny stock picks
Access 07
I have this invoice form, with some info on like Order Total, Payments, Sales Tax etc just what youd expect on an invoice,
In the Payments (Unbound) I have this code
=IIf(IsNull([WorkorderID]),0,DSum("[PaymentAmount]","Payments","[WorkorderID]=" & [WorkorderID]))
Default value is 0.00
However, if I have just created a new workorder, then nothing shows in the "payments" field, unless I goto my other form "make Payment" and delect the Amount to be paid and put a 0 in
Any help?
All other calculations work perfect, and the reason I need this to work is I have a report that shows un-paid accounts, and if there is nothing in the payment field, it shows it as being unpaid

Cheers
CCK
________
Penny stock picks
Last edited: