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

  • Thread starter Thread starter R Tanner
  • Start date Start date
R

R Tanner

Hi,

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

Thanks
 
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
 
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.
 
Back
Top