Queries Show checkbox questions

  • Thread starter Thread starter Gibson
  • Start date Start date
G

Gibson

I'm using a query to supply data for a combo box. I want to use the data
retrieved from the query to load into controls on the form but I don't want
all the data to show in the combobox pull down. I thought that by adding
fields in the query and unchecking their Show box they would be in the query
for use on the form but not show up in the pulldown. Not so. When I save
the query and then open it again in design mode the fields that I unchecked
the Show are not there and when I run the query they are not there. Is
there a means to do this?
Thanks
 
Gibson,

Include all the fields in the query, and set the query as the Row Source
of the combobox. Then you can control which data is shown on the
combobox's drop-down list by manipulating the combobox's Column Count
and Column Widths properties. For example, if you set the Column Count
property to 3 and the Column Widths to 0;2.5;0 then the first 3 fields
of the query will be available to the combobox, but only the second
column will be visible, with a width of 2.5 inches or cm, in the
drop-down list.
 
Back
Top