after update event

[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...

 

[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.

 

[scubadiver]

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

 

[Klatuu]

Yes, but since I seldom use continuous forms, I don't know that I can help.