enable/disable buttons in tabular form

G

galneweinhaw

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
 

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 button in tabular form 3
Enable/Disable button on Tabular Form 0
Program buttons to create a word document 0
Dynamic Naming of Form Button 3
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Macro to Select text from a point given to a specific word 2
Clearing Fields in a Word Form 5
VBA word change keys 0

Top