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.
 

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

Limit combo box selection based on another field value 1
Combo Box Value question 4
Query with results in a value list from a combo box? 1
Using combo box(s) to create a query 1
Choose a value from a combo box based on a text box 0
Combo Box in a Query 3
Exicute an append query in an after update event 0
Default Value for Combo Box 1

Top