It may be very simple, but I want to have certain fields in my form auto fill with field values from other fields from the same table. Lets say I have a part number and a description, if I select a part number from a drop down menu (combo box), how do I make sure that the corrisponding description pops up automatically in the form field I created for it. In general I'm not getting how to get corrisponding fields to populate the form. Am I making any sense?

I use
Private Sub ProductID_AfterUpdate()
Me.UnitPrice = Me.ProductID.Column(2)
End Sub

to add the unit price when selecting a part, but can't seem to get it to work for more than one box.