Using two fields from a combo box in two different fields

[Silvio]

I have a combo box on a form which links to a table with two fields:
UserName and OfficeID. I want to be able to select the User from the combo
Box and and store it in myTable.User (so far not a problem) and the OfficeID
in myTable.OfficeID. Any ideas how can be done? Since the User will not
always use the same OfficeID it is ***imperative*** to store the current
OfficeID in the database. My Form is based on the main data table for record
addition and I am using a combo box to lockups data from a second table.

Thank you,
Silvio

 

[Klatuu]

In the After Update event of the combo:
Me.OfficeID = Me.MyCombo.Column(1)

 

[Silvio]

Thank you so much, it works just fine.

In the After Update event of the combo:
Me.OfficeID = Me.MyCombo.Column(1)