Combo box question 1

[robmkimmons]

On a form I have a combo box [cboCorrType] that has a list of options with the last option being called "Other". Beside this combo box i have another field [txtCorrDesc] that is disabled.

What i would like is to have the disabled field become enabled whenever the user selects "Other" from the combo box (allowing the user to specify in the newly enabled field what the "other" is). I have tried several coding options but to no avail. Also, what is the best place for this code... on the "After Update" event?

Much thanks for any input!!

~Rob

 

[JoeMiller]

In the AfterUpdate event of cboCorrType place this code:

If Me.cboCorrType = "Other" Then
Me.txtCorrDesc.Enabled = True
Else
Me.txtCorrDesc.Enabled = False
End If

That should do it!

Joe Miller
joe.miller@flotech.net

 

[robmkimmons]

hey Joe,

many thanks!!

...after a little tweaking it works great! thanks for pointing me in the right direction.

~Rob