Field Query in Form Desgin (1 Viewer)

[Jo8701]

Hi Guys

This is prob a small thing but I have a Form and included are two fields

IPT (Yes/No box)
IPT Amount

I want to have it so IPT Amount is shaded out but if the user clicks yes in the box the IPT Amount box becomes unshaded?

Appricate any help on this thanks

 

[JANR]

Private Sub IPT_AfterUpdate()
Me.[IPT Amount].Enabled = Me.IPT
End Sub

You must repeat the code in the Form's OnCurrent event to keep it in sync when scrolling through records.

JR

 

[JANR]

If you don't like code you can also use conditional formatting

Expression is: [IPT] <> 0

JR

 

[Jo8701]

Thank you very much