enabling field

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?
 
P

pietlinden

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
 

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

Field required only if visible 1
Clearing text boxes based on combo selections 3
Pasting cell contents into a macro 1
Accessing the fields from mailmerge document after databasefield u 1
Calculating averages on a form 3
Access 2010 Data Macros: The Three-Legged Hunting Dog With One Bad Eye 27
Query methods 3
color of field in each record of datasheet depends on other field 1

Top