Autopopulate a combobox from another combobox

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Greetings all!
I have a form based on a table. In the form i have a combobox named "Type"
and another combobox named "category". When i enter a new record and when i
choose the option "NT" in the Combobox "Type" i want option "NTCASE" to be
populated in the combobox "category". I have tried the below without
success...Ambigious anme etc appears as a "error message"..

Private Sub Type_AfterUpdate()
Very thankfull for suggestions!
 
Private Sub Type_AfterUpdate()
If Me.Type.Value = "NT" Then _
Me.category,Value = "NTCASE"
End Sub
 
Back
Top