after update event

  • Thread starter Thread starter scubadiver
  • Start date Start date
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...
 
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.
 
It doesn't work. I should have mentioned the form is continuous. Would that
complicate things?
 
Back
Top