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

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

"R Tanner" wrote in message
...
Hi,

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

Thanks

On Oct 16, 10:18*am, "Jeff Boyce" wrote:
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 Tanner" wrote in message

...



Hi,

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

Thanks- Hide quoted text -

- Show quoted text -

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