Disabling the second combo, if a value selected from the first combo & vice versa.

[peterock]

Hi,
I am new to access & trying to learn access myself.
I have designed a db & has 2 combos. Each combo represents a category. If something (a value) is selected from combo1, the other combo should be either disabled OR show an error. And vice versa.
Basically user can select a value either from combo1 OR combo2.
How would I accomplish this?

[pbaldy]

I'd be curious about the design, but you could adapt this:

http://www.baldyweb.com/ConditionalVisibility.htm

[peterock]

thanks pbaldy.That's not what I am looking for!
I will elaborate my problem.
I have to combo boxes - Chocolate & Icecream. Both the combos have drop down list.
User can select either one variety from Chocolate OR one flavor from Icecream. Not from both.
I have attached the sample db.Database2.accdb

[pbaldy]

Not sure what you want then. That code could be used to disable the ice cream combo if a selection was made from the chocolate combo, or vice versa. I didn't say that was an out-of-the-box solution, I said you could adapt it. In your case, you'd test that something (anything) was chosen, rather than test for a specific selection.

[peterock]

ok, Thanks.
instead of disabling (invisible), how can i grey out the box?

[pbaldy]

The Enabled property will grey it out. The Visible property will make it invisible.