after update event

S

scubadiver

hello,

I have two combos.

When the first combo is changed from "pending" to "live" I want the second
combo to become enabled.

I have the following in the after update event.

If Me.StatusID.Value = "Live" Then Me.MonthID.Enabled = True

but it isnt working.

It has been awhile...
 
K

Klatuu

You also have to requery the second combo

If Me.StatusID.Value = "Live" Then
Me.MonthID.Enabled = True
Me.MonthID.Requery
End If

Note: Single line coding is poor form.
 
S

scubadiver

It doesn't work. I should have mentioned the form is continuous. Would that
complicate things?
 
Top