Making fields conditional on Data Entry Forms

J

Jared

I have a data entry form with several combo boxes; I would like to make a
text box conditional on the value of a combo box above it. I only want the
text box available if the combo box is set to a specific value. Otherwise, I
want the text box grayed out/ unavailable. Is this possible? How do I
structure an expression for this?
 
F

fredg

I have a data entry form with several combo boxes; I would like to make a
text box conditional on the value of a combo box above it. I only want the
text box available if the combo box is set to a specific value. Otherwise, I
want the text box grayed out/ unavailable. Is this possible? How do I
structure an expression for this?

And what is that 'specific value'?

Set that text control's Enabled property to No (grayed out).
Code the combo box AfterUpdate event:

Me.[TextControlName].Enabled = Me.ComboName = "What?"

Place the same code in the Form's Current event.
 

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

Top