Simple query/combo box question

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

When I run my query it displays all the values I want.
However when I put the query in a combox box it only shows part of the data.
Columns 0,1 are blank as are 8,9?

Yet when I run the query on its own the data is there??
 
Did you set the combo to have 9,10 columns or however many you need? What is
the control source of your query? Is the query pulling all the data you need?
 
Open the form in design view. (You ARE talking about a form, right?)

Click on the combobox control and select Properties.

How many columns are included in the Row Source? What Column Width(s) are
shown for these?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
This is a form. When I select the drop down there are columns and widths
but no data in the first two columns, or the last two columns.
 
The control source of my query is an linked excel file.
The query works fine when run in the query section of access showing all
fields.
 
From your description, it doesn't sound like you are working in design view.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Row Source qryOpenJobs
Column Count 13
Column Heads No
Column Widths 1";1"
Bound Column is 1
List Rows 8
List width 2"


I revised my query to 7 columns.
 
Also if I make a blank from and make a combo box based on the query I am
getting no data as well.
 
Try making the Column Count equal to the number of columns in the query.

There is a bug introduced when you installed service pack 3 to Access
2003 that can cause this type of behavior with comboboxes.

Change Column Count to 7 (assuming your query source for the combobox
returns 7 columns).

If that fails and you do have 2003 with SP3 there is a hotfix available
at Microsoft.com that should fix this problem. Check Allen Browne's
site for the URL if you can't locate it on MS site.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top