Combo box

[daleshei]

I have a form with a combo box populated by a Table which contains a list of agencies.

e.g.

Agency1
Agency2
Agency3
Agency Other (pls specify)

I have a text box next to the combo box and I want it to be greyed out and only enable it
when the user choses "Agency Other (pls specify)" to type the other agency.

Any idea on how to do this in VBA?

Thanx in advance

D

 

[TheAceMan1]

How are ya daleshei . . .

In the [blue]AfterUpdate[/blue] event of the combobox:

[blue]   Me.[purple][b]TextboxName[/b][/purple].Enabled = (Me.[purple][b]ComboboxName[/b][/purple].Column(1) = "Agency Other (pls specify)")[/blue]

You might have to play with the column index [blue]Column([purple]x[/purple])[/blue]. Note: column index starts at zero and includes any hidden columns in the [blue]Column Widths[/blue] property.

See Ya! . . . . . .

 

[daleshei]

Thanx for the code, here's another problem

The txtbox is not greyed out and only gets greyed out when I chose Agency 1,2 or 3. Is there a way of greying it out permanently and only appears when I chose "Agency Other"?

Also if the txtbox wasn't greyed out on the previous record and I create a new record the txtbox is still not greyed out.

Thanx again

D

 

[TheAceMan1]

daleshei . . .

Run the code from the [blue]On Current[/blue] event of the form as well . . .

See Ya! . . . . . .