Autopopulate a combobox from another combobox

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

 

[Ken Snell MVP]

Private Sub Type_AfterUpdate()
If Me.Type.Value = "NT" Then _
Me.category,Value = "NTCASE"
End Sub

 

[Peter]

Thank you Snell, it works perfect!...

Private Sub Type_AfterUpdate()
If Me.Type.Value = "NT" Then _
Me.category,Value = "NTCASE"
End Sub


--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/