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 / Forms / October 2007

Tip: Looking for answers? Try searching our database.

Use Query for Combo Box Source - Posted 26 Oct 07

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rick - 29 Oct 2007 20:04 GMT
Reposting because I feel it may not receive any attention since it was
originally posted last week.
--------------------------------------------------------------------------------------------
Steve, here is the info you requested:

Row Source  = SELECT [EPR/TR/OPR].[FullName] FROM [EPR/TR/OPR];
Column Count  = 1
Column Widths  = 1.7605"
List Width  = 1.7604"
Bound Column  = 1

Thanks, Rick

"Steve Schapel" wrote:

> Rick,
>
> In design view of the form, can you select the combobox, and look at the
> Properties.  Can you post back with what is entered in there for these
> properties:
>
> Row Source
> Column Count
> Column Widths
> List Width
> Bound Column
>
> > Similar to JHC message and I tried fredg recommendations with no luck.
> >
> > Running Office 2003 Professional Edition 2003
> > Converted database from 2000 to 2003 (problem existed in 2000 as well)
> > Created Combo Box w/control wizard
> >
> > I can create the Combo Box usin the wizard, select required fields (only
> > need one but tested to see if it happens w/all fields which it doesn't.  I
> > can see data for column one, primary key) and while still in the wizard, the
> > combo box is displaying all information I'm looking for.
> >
> > Once I finalize wizard, switch to form view, the only data displayed in the
> > combo bix is bound to colunm one, the primary key.  All other fields are
> > blank.  I tried changing the Bound Column, Column Widths, and Column Count as
> > recommended by fredg but I don't see data for the fields I need.  I can see
> > the columns but they are all blank except for column 1.  Any thoughts as to
> > how I can get the combo box to display all of the data?
> >
> > Thanks in advance!

 Was this post helpful to you?        

 Why should I rate a
SteveM - 29 Oct 2007 20:35 GMT
You will only see one field in a combo box no matter how many are in the
RowSource. If you want to see multiple fields you need a Listbox.

Steve

> Reposting because I feel it may not receive any attention since it was
> originally posted last week.
[quoted text clipped - 46 lines]
>  
>   Why should I rate a  
Rick - 30 Oct 2007 16:45 GMT
Thanks Steve,

I'm really only interested in seeing one row but I was having issues seeing
that row so as a test, I pulled two rows to see if any data came through.  As
it turns out, the data from the primary key does come through but I still
don't see the data from the one field I need, user name.

Thoughts?

> You will only see one field in a combo box no matter how many are in the
> RowSource. If you want to see multiple fields you need a Listbox.
[quoted text clipped - 51 lines]
> >  
> >   Why should I rate a  
 
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.