How do I "tag" along a combo box field ? (1 Viewer)

dcavaiani

Registered User.
Local time
Today, 08:17
Joined
May 26, 2014
Messages
385
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

AWF VIP
Local time
Today, 13:17
Joined
Jul 26, 2013
Messages
10,354
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

Super Moderator
Staff member
Local time
Today, 09:17
Joined
Jan 23, 2006
Messages
15,362
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

MVP / VIP
Local time
Today, 13:17
Joined
Jan 14, 2017
Messages
18,186
I'm guessing 'tag' is being used in the sense of 'marking' a specific record for further action.
 

dcavaiani

Registered User.
Local time
Today, 08:17
Joined
May 26, 2014
Messages
385
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 !
 

Users who are viewing this thread

Top Bottom