One record at a time

[Zippyfrog]

I have a continuous form with a check box (chkDNR) a combo box (Combo20) and a textbox (txtReason).

When the check box is clicked, I want the combo box to be hidden and the text box to be shown, and when it isn't checked I want the combo box to show and the text box to be hidden.

Here is the code that I added to the AfterUpdate procedure:

If chkDNR = True then
Combo20.visible = False
txtReason.visible = True
Else
Combo20.visible = True
txtReason.visible = False
End If

The code works great and does what I want it to do, but it does it to all records on the continuous form. How can I make the combo box hidden and the text box show on only the specific record where the checkbox is checked??

-Chris

 

[llkhoutx]

That's the way continuous forms work.

Try using the conditional format to change the color of the field(s) to the background color on the form.