MS Access 2007, Query only shows first field

Hello I have a form with a combo box that I want to show the results of a query in.

I set the controls record source to a query that selects 42 total fields.

When I run the query it shows everything I want.

However when I apply the query to the combo box it only shows the values for field 1, not all the values for every field per record. Like I want.

How do I specify the list of values to be from every field? I can add pictures if need be.


  • Edited by Ryonite Wednesday, May 06, 2015 7:51 PM grammar
May 6th, 2015 7:43pm
Is this a property in Access 2007's combo box property on the form or the query? I have found the column count for the fields within the query design but changing any one of them to 42 does not affect the number of items on the forms combo box.
Free Windows Admin Tool Kit Click here and download it now
May 7th, 2015 8:28am

It is a property of the combo box, in the Format tab of the Property Sheet:

May 7th, 2015 8:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics