How do I "tag" along a combo box field ?

[dcavaiani]

I have a Customer Field and a Job# field as a key.

The form has a dropdown for the Customer which is populated with a Query, The query pulls the Customer and the Job#.

The form shows the Customer as 1 field (combo box) and the Job# as a separate input field (as text box).

What I need to do is to get the Job# from the Combo box selection auto moved into the form Job# field.

 

[Minty]

The second column of the combo can be used using VBA in the after update of the combo

Me.yourtxtBox = Me.YourCombo.Column(1)

Column numbering starts at 0 , so this would pull the second column.

 

[jdraw]

I think this is a case where a picture would help the discussion. I'm not following the essence of your post. "Tag" has a specific meaning (property) in Access, but it doesn't seem to apply here. Perhaps you could expand on description of the issue.

Sounds like a composite PK..

 

[isladogs]

I'm guessing 'tag' is being used in the sense of 'marking' a specific record for further action.

 

[dcavaiani]

The second column of the combo can be used using VBA in the after update of the combo

Me.yourtxtBox = Me.YourCombo.Column(1)

Column numbering starts at 0 , so this would pull the second column.

Awesome, done, works - Thank You !