Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

combo box bound columns

Status
Not open for further replies.
ronmon

ronmon

IS-IT--Management
Feb 25, 2002
66
IE
is there anyway way to point towards a different column in a combo box instead of the bound column using VBA
 
Sort by date Sort by votes
you can do something like this:

Dim colValue As String

colValue = Me.Combo1.Column(1, 1)

where the first 1 in the parameter is the column number and the other 1 is the row number.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
656
dhookom
dhookom
monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
511
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
535
visitnag
visitnag
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
3K
JanaLNelson
JanaLNelson
dhookom
  • Locked
  • Question
Make second combo box display records dependant on selection from first combo box 1
Replies
2
Views
390
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top