enabling field

  • Thread starter Thread starter Ryan Hess
  • Start date Start date
R

Ryan Hess

In a database I'm creating I have a scroll down field with fixed values.
When a certain value is selected I want some other fields to become enabled.
I want these fields to be disabled unless that value is selected. I'm sure I
need to run some kind of a macro or something but up to this point I have
only done basic things in Access. Can anyone help me?
 
In a database I'm creating I have a scroll down field with fixed values.  
When a certain value is selected I want some other fields to become enabled.  
I want these fields to be disabled unless that value is selected.  I'm sure I
need to run some kind of a macro or something but up to this point I have
only done basic things in Access.  Can anyone help me?
Click to expand...

put code in the AfterUpdate event of the control.

Sub SomeControl_AfterUpdate()
ControlA.Enabled = (SomeControl = "Value 1")
ControlB.Enabled = NOT (SomeControl = "Value 1")
End Sub
 
Back
Top