make a VBA button to disable a text

[allenEd]

Hi,

I have a form with a continuous subform in it. In the subform, if I make a VBA button to disable a text box called txtBox, every txtBox in the form (continuous) is disabled. How do I get the button to disable only the record that the button is clicked in to be disabled.

eg. the code is


Private Sub cmdTxtBoxDisable_Click()
Me.txtBox.Enabled = False
End Sub


many thanks!
Allen

 

[RuralGuy]

You will need to use conditional formatting to achieve the results you want.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit