enable button in tabular form

T

tylerecouture

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
 
C

Chris Eberhart

I do this with conditional formatting on the field which I
wish to enable/disable.
 
V

Van T. Dinh

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

enable/disable buttons in tabular form 0
Enable/Disable button on Tabular Form 0
Enable-Disabled field 1
HOW TO - put "ticks" instead of the X check box in your Word forms 0
Append table form current Subform - tick row exported 0
Clearing Fields in a Word Form 5
Trouble with cmd button 3
Setting up function on access forms 1

Top