Enabling a Combo Box Based on the Value of another Combo Box

R

R Tanner

Hi,

How would I enable a combo box ONLY based on the value of my current
combo box..?

Thanks
 
J

Jeff Boyce

How is this a ".queries" post? (this newsgroup supports questions about the
use of the feature in Access called "queries")

If you are asking a "forms" question, then open the form in design view, add
an event procedure to the first combobox's AfterUpdate event, and use
something like the Case statement to determine what was selected. Then
you'd use something like the following to enable combobox2:

Me!Combobox2.Enabled = True

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

R Tanner

How is this a ".queries" post?  (this newsgroup supports questions about the
use of the feature in Access called "queries")

If you are asking a "forms" question, then open the form in design view, add
an event procedure to the first combobox's AfterUpdate event, and use
something like the Case statement to determine what was selected.  Then
you'd use something like the following to enable combobox2:

    Me!Combobox2.Enabled = True

Regards

Jeff Boyce
Microsoft Office/Access MVP








- Show quoted text -
Click to expand...

Perfect. It works wonderfully. Sorry about posting in the wrong
forum.
 
Top