Conditionally Enable a Button Based on Value of a Field

S

Steve Johanson

I have a button (Command96) that I want to enable only if a certain value ([WIP Primary]="Yes") in a field is met. How do can I do this

Stev
 
K

Ken Snell

The code to do this is simple:

Me.Command96.Enabled = (Me.[WIP Primary].Value = "Yes")


The trick is to identify which event should run this code step. You may want
to use the AfterUpdate event of the WIP Primary control:

Private Sub WIP_Primary_AfterUpdate()
Me.Command96.Enabled = (Me.[WIP Primary].Value = "Yes")
End Sub


--
Ken Snell
<MS ACCESS MVP>

Steve Johanson said:
I have a button (Command96) that I want to enable only if a certain value
Click to expand...
([WIP Primary]="Yes") in a field is met. How do can I do this?
 

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

Hiding a button based on a value in a table 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Mail Merge Directory Conditional Page Break 0
Filtered view of Visio Chart 0
Finding the right style field in VBA 0
Returning 1 of 4 values if conditions are met 4
Conditional formatting of detail section in an access form 4
Finding the proper style field and the numbered paragraph value within the style 0

Top