Hey guys, Thanks in advance for any help. This is probably a very simple thing for some of the guys here but have searched and cant find anything.
I have a tabular form for users to enter items into. I have a checkbox for them to select if this item is a certain type, and I want that checkbox to disable a few textbox's and enable a few textbox's. Basically, if it's checked, enable these, uncheck enable the other ones. I'm trying to do this so that the users don't waste time entering information that isn't needed for that type of item, but I also don't want a seperate form for these items as all of this goes hand in hand and is very useful to have all together on one form.
I currently have this code:
Private Sub CheckIndPr_Click()
If CheckIndPr.Value = False Then
Combo49.Enabled = False
Combo50.Enabled = True
Else
Combo49.Enabled = True
Combo50.Enabled = False
End If
End Sub
My problem is that the code is being applied to every single row of the form. I have 10 items entered and if I check just one of the boxes, say on row 3, it disables Combo50 for all 10 rows etc. Is there a way to make a code like this work for only that 1 row?
Thanks!