Create an Optional Field

[soupisgood84]

I am trying to create an optional field that only becomes available under certain circumstances.
I have a combo box that has many options in it, and the field is restricted to list/look-up only. When the selection isn’t on the list, I would like the use to pick “other”; then in another field enter what it is. The catch is that I want the field to remain locked or grayed out until the selection “other” has been picked.
Any ideas would be greatly appreciated.

 

[Remou]

This is a similar idea:
Field not displayed
thread702-1357550

 

[soupisgood84]

Kinda similar but backwards. Also that only makes the the color of the field change so you cant see it; if you tabbed over you could still enter data.
Any other ideas? Thanks

 

[Remou]

Consider PHV's response in the thread linked above.

 

[TheAceMan1]

How are ya soupisgood84 . . .

In the [blue]After Update[/blue] event of the combobox:

[blue]   Me.[purple][b][i]FieldName[/i][/b][/purple].Enabled = (Me.[purple][b][i]ComboboxName[/i][/b][/purple].Column(1) = "other")[/blue]

See Ya! . . . . . .