enable button in tabular form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a tabular form with a tick box and button for each record. I want the tick box to enable/disable the button. Right now when ANY record's tick box is checked/unchecked ALL the buttons enable/disable.... how do I make it so each button responds to it's own record's tick box?


Dim boolBaked As Boolean
boolBaked = Me!Baked
If (boolBaked = True) Then
Me!btnEditBakeDetails.Enabled = True
End If
If (boolBaked = False) Then
Me!btnEditBakeDetails.Enabled = False
End If
 
I do this with conditional formatting on the field which I
wish to enable/disable.
 
AFAIK, you can't. What you see is many instances of the
*same* CommandButton. Hence all instances are either all
Enabled or all Disabled.

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
I have a tabular form with a tick box and button for each
Click to expand...
record. I want the tick box to enable/disable the
button. Right now when ANY record's tick box is
checked/unchecked ALL the buttons enable/disable.... how
do I make it so each button responds to it's own record's
tick box?
 
Back
Top