Enable Textbox if another combobox contains "Other"

[m33hdy]

Hi all,



Just wanted to clarify the VBA code required to enable a text box if another combobox contains the word "Other"?



The name of my combobox is "Cardiac" and the name of the textbox i wish to Enable is "Other". The code i'm using at the moment is as follows but doesen't seem to work

Private Sub Cardiac_AfterUpdate()If Me.Cardiac.Text = "other" Then
Me.Other.Enabled = False
Else
Me.Other.Enabled = True
End If
End Sub

Any help much appreciated

[isladogs]

You need to use wildcards
Change ="Other" to Like "*Other*"

Then swop your true and false satements

[m33hdy]

Thanks, you mean like this?

Private Sub Cardiac_procedures_or_conditions_Click()If Me.Cardiac.Text Like "*Other*" Then
Me.Other.Enabled = True
Else
Me.Other.Enabled = False
End If
End Sub

Not working for me

[isladogs]

May just be an issue when you uploaded but it should be

Private Sub Cardiac_procedures_or_conditions_Click()
If Me.CardiacProcedure Like "*Other*" Then
Me.Other.Enabled = True
Else
Me.Other.Enabled = False
End If
End Sub

This assumes your textboxes are called CardiacProcedure and Other.
If not, modify as appropriate.
If the names contain spaces enclose in square brackets []
Do not use .Text in the code

[m33hdy]

Thanks again. Still doesn't seem to work. I've made sure that my textboxes are named as per above (i.e. CardiacProcedure and Other)







code used:

Private Sub CardiacProcedure_Afterupdate()If Me.CardiacProcedure Like "*Other*" Then
Me.Other.Enabled = True
Else
Me.Other.Enabled = False
End If
End Sub

I changed the Click event to AfterUpdate

[isladogs]

AfterUpdate event is correct. Not sure how I missed that before.
Check that it says Event Procedure next to the after update event in the property sheet.

If that's not the issue then I'm baffled

[Minty]

What is the bound column data for the CardiacProcedure combo ?
Is it "Other" or is its row source a table and your storing the ID ?

Also slightly worried in your picture that you have tables called Treatment 1 , 2, 3, 4 and 5...
This sounds like the same basic data being stored in separate tables which is a probably a bad idea. Can you elaborate?