How to write an If Statement 1

[integritycare]

Hello,
I hope my subject is correct!

On an invoice form I wanted need code to do the following.
There are two text boxes involved.
BalDue (Currency)
Status (Text)

What I wanted to do was this, When the "status" text box is changed to "Paid"(via a combobox - selection) then "BalDue" would = $0.00.

I'm just not sure how to do this. I huess it could be done with conditional formatting, would this be correct?

Many Thanks,

Integrity

 

[PHV]

I'd use the AfterUpdate event procedure of the Status textbox.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[integritycare]

Hi PHV,
Many thanks for your reply.
Would yo ube able to help me write the code for this.

Thankyou,

Integrity

 

[PercyN]

If Me!Status="Paid" then
Me!BalDue=0
End if