I have been doing a data base to collect my invoices and enter the payments in full or in small amounts.
I have a form [frmInvoice] that has fields [InvAmount] for total amount in the invoice, [SumPaid] for total amount paid in the subform, [Balance] that shows total balance amount of [InvAmount]-[SumPaid], and I have inserted a Paid [imgPaid] stamp image in the form.
I want make the image [imgPaid] visible if the invoice is paid if the [Balance] amount is "0" or the values in [InvAmount] and [SumPaid] are same. If there is no payment made, [SumPaid] and [Balance] fields shows blank.
I'm not a pro for access but for me Macro Builder is easy to use and I do prefer it for these commands. If not code builder is also fine.
Please help....
Thank you