Combo box which enable/disables another combo box

[Dugantrain]

I'm trying to use two different combo boxes. The first, CmbCharges, gets its data from the Charges table. The second, CmbOtherCharges gets its data from the OtherCharges table. What I need is for the CmbOtherCharges combo box to be disabled by default. When the user selects "Other" from the CmbCharges combo box list, the CmbOtherCharges combo box becomes enabled. I assume that I should use the AfterUpdate event, but I haven't been able to find the code to properly do this.

 

[Geoff Codd]

on the after update event for CmbCharges put the following VBA

If Me!CmbCharges = "Other" then
Me!CmbOtherCharges.Enabled = True
Else
Me!CmbOtherCharges.Enables = False
Endif