Using two fields from a combo box in two different fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In the After Update event of the combo:
Me.OfficeID = Me.MyCombo.Column(1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form - Lock Fields from Editing 0
Help in writing SQL statement 2
Combo Boxes - DISPLAYING multiple fields after choice is made 5
Append Query that won't add any records 4
filter on combo box possible? 1
Expression to link two tables together not working 5
Two Combo Boxes 3
Using two fields from a combo box in two different fields 5

Back
Top