Paid image visible if balance is zero or invoice amount and paid amount is same

[Amigo]

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

[ranman256]

put this in the ON CURRENT event of the form, (to run after each record you land on)
and the AFTERUPDATE of the entry textbox (to run after you enter an amt)

sub InvAmt_afterupdate()
   ShowImg
end sub

sub form_OnCurrent()
   ShowImg
end sub

sub ShowImg()
if IsNull(balance) then
   imgPaid.visible = false
else
   imgPaid.visible = balance = 0
endif
end sub

[andy49]

Sounds like an form_current event

If balance=0 or etc etc then
imgpaid.visible= true
Else imgpaid.visible =false
End if

[June7]

Why do you need an image? Why not just a text box with large font?

Is the form in Single view? Is the image embedded in an Image control with the Picture property? Or are you using an OLEUnbound control?

The real trick is figuring out what event to put code into. Probably want to use form Current event and also form BeforeUpdate or textbox AfterUpdate.

Me.controlname.Visible = Me!Balance = 0

This will not work nice if form is Continuous or Datasheet because setting the Visible property of the control will be reflected in all records. And I don't think image will show in Datasheet any way. Could have text display conditionally with expression in ControlSource. Or if the image is in an external folder, it can be conditionally displayed with expression in ControlSource property of Image control.

[Amigo]

Thanks.
I tried that but did not work. I did set the image visibility to "No".

[Amigo]

[QUOTE=andy49;360127]Sounds like an form_current event

If balance=0 or etc etc then
imgpaid.visible= true
Else imgpaid.visible =false
End if

Thanks.
I tried that but did not work. I did set property of the image visibility to "No".

[June7]

You have to put whatever condition is appropriate in place of 'etc etc' if any is needed.

And make sure you are using the actual names of your controls.

There is alternate code in post 4.

[Amigo]

This is solved as Andy49 as told but not in the way I wanted. I had to put a text box as June7 told, image didn't work with the codes.

Thanks for the help.