Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / November 2005

Tip: Looking for answers? Try searching our database.

Display all columns of a combo box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peg - 19 Nov 2005 20:39 GMT
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
Ken Snell [MVP] - 19 Nov 2005 21:20 GMT
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).

Signature

       Ken Snell
<MS ACCESS MVP>

> 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
[quoted text clipped - 5 lines]
> budget
> meeting....grrrr
John Vinson - 19 Nov 2005 21:36 GMT
>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]    
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.