Re: Display all columns of a combo box
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 19 Nov 2005 14:36:31 -0700
On Sat, 19 Nov 2005 12:39:01 -0800, Peg
<Peg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>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.
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]
.
- Prev by Date: Re: Display all columns of a combo box
- Next by Date: Re: Same Query + OK in SQL Server + Error in MS Access: E_FAIL........
- Previous by thread: Re: Display all columns of a combo box
- Next by thread: Including zero-sales months.
- Index(es):
Relevant Pages
|
