Show other fields automatically after making a choice in a combo box 1

[MattMeat]

Hello everyone,

I am trying to make a Pre-receive form for our warehouse.
I have a combo box called "ITEM" that drops a list of of item numbers. The two fields that follow this combo box on the form are "Description" and "MFG". I really need the latter two fields to show/update the corresponding info. after a choice is made in the combo box--Upon selecting an Item number, the Description and MFG should show automatically.
If anyone can help, I would really appreciate it and I'm sure the warehouse employees would too.

Thank you,
Matt

 

[leobaby]

I have a database with customers and routes. When I choose a customer, I want it to fill in the route automatically. The row source for the customer combo box includes the column with the route number. Remember column 0 is the first column and column 1 is the second. I created an event for the customer combo after update. Here's the code. There are other ways to do this if this doesnt work for you.


Private Sub Customer_AfterUpdate()
On Error Resume Next
Me![Route] = [Customer].Column(3)
End Sub

 

[MattMeat]

Thanks Leobaby,

I really appreciate the help! Glad you responded.
Keep up the good work!
I'm sure you'll see my name around this forum again.

MAtt