Re: Display all columns of a combo box
- From: "Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 19 Nov 2005 16:20:46 -0500
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).
--
Ken Snell
<MS ACCESS MVP>
"Peg" <Peg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2DE8F186-BA23-43A6-8684-4464457D7806@xxxxxxxxxxxxxxxx
> 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
.
- Prev by Date: Re: Removing leading zeroes from a text field
- Next by Date: Re: Display all columns of a combo box
- Previous by thread: Re: Only show Last Four numbers of SSN
- Next by thread: Re: Display all columns of a combo box
- Index(es):
Relevant Pages
|
