Display all columns of a combo box

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

Guest

Oh my...I'm having a very difficult time trying to do this...and I at this
point could certainly use a bit of a step-by-step approach. I'm trying to
get all the columns in a combo box in a query to make a report from.

My combo box has an account number then an account description I can get
the account number but I can't seem to get the account description for my
report. I need immediate help for this as this is due by Monday for a budget
meeting....grrrr
 
Not sure just what you seek... the .Column(x) property of the combo box
allows your form to read the values of the other columns (x is the number of
the column; .Column is zero-based, so the first column is 0, second is 1,
etc.).

However, a query cannot read the .Column property of the combo box, so if
this is what you want to do (note: because the combo box is filled by a
query, you could just use the same query as a table in your query...), then
use a public function that reads the .Column property of the combo box and
returns that value as the function's value).
 
Oh my...I'm having a very difficult time trying to do this...and I at this
point could certainly use a bit of a step-by-step approach. I'm trying to
get all the columns in a combo box in a query to make a report from.
Click to expand...

I think you're giving too much weight to the fact that you see the
data displayed in a combo box.

The data is NOT stored in a combo box. It's stored in a Table; you can
display that data on a Form, in a Listbox, in a Combo Box, or - and
this is the likely solution to your problem - in a Query.

Simply join this combo box's Rowsource table to the Query upon which
the report is based. You'll now have all of that table's fields
available for display in the report.

John W. Vinson[MVP]
 
Back
Top