Bound Column on Combo Box

  • Thread starter Thread starter Dale.Utterback
  • Start date Start date
D

Dale.Utterback

I'm building a database for one of my guys. It requires
me to build combo boxes which pull data from a table. The
problem is that this table has nine columns, and
regardless of what I've tried it only pulls data from the
one column that is "bound". Is there anyway to get it to
pull data from any of the nine columns?
 
I'm building a database for one of my guys. It requires
me to build combo boxes which pull data from a table. The
problem is that this table has nine columns, and
regardless of what I've tried it only pulls data from the
one column that is "bound". Is there anyway to get it to
pull data from any of the nine columns?
Click to expand...


It's not clear what you mean by "pull data from any of the
nine columns".

In case you just want to display the other columns from the
combo's table, set the combo's RowSource to a query that
retrieves all the fields:

SELECT fielda, fieldb, . . . FROM thetable ORDER BY fieldx

Then you can use eight other text boxes with expressions
like:

=thecombo.Column(N)

to display the other columns. Note that N is zero based so
Column(3) refers to the fourth field in the query.
 
Back
Top