Populating Text box from combo box

[ssworthi]

I have been struggling with this for two days now and am at the point I need to consult the experts. I know this topic has been discussed at nausium but whatever I try I have yet to be successful so here goes.
I have a Mgr Vehicle Usage table that tracks business and personal miles of company driven trucks.
I have a second table called Mgr Tbl that has the Vehicle # and the Mgr that drives that vehicle.
I have created a data entry form and have created a combo box based off of the Mgr Table which reflects Veh #. I would like to create a text box (I believe?) for vehicle operator that would populate based on the Veh #. How best to accomplish this? Thanks so much for any help!

 

[DCrake]

Set the rowsource for your combo to the mgr table

Select VehicleNo,Manager From Table

Column Count = 2
Bound Column = 1
Column Widths 3cm,3cm

After Update of Combo

Me.TxtManager = M.Combo.Column(1)

Column number are zero based.

If you want to ad further information to the combo remember to set the properties to the correct values. Also you can hide columns by setting the column width to 0cm.

 

[ssworthi]

thank you so very much; not quite clear on some things but will post again tomorrow as it's time to go home. First question; in the row source, is it just mgr table or do I select both fields for the row source from the mgr table? This is all new to me so please bear with me. Thanks again; until tomorrow.

 

[ssworthi]

The "Me.txtManager" etc; is that in the combo box or is that in the text box for operator? What I had hoped was that the user would use the Veh # drop down combo and then below the combo have a text box populate based on the Veh #. Sorry for being slow and thanks so much.