drop down lists

P

Patrick Stubbin

Is there a way to format drop down lists that are based on a sub query for
teh control within the combo box field. at the moment i hve one where i have
formatted the underlying query in its query design view, but cannot duplicate
this layout (colours etc) when it is in the dorp down list of the combo box.
 
J

JohnFol

Patrick, queries do not have "colour", they mearly sort / filter and select
data. All formating is done on a form or report.

Can you explain further what you want the Combo to look like, irrespective
of its recordsource?
 
P

Patrick Stubbin

I realise what i typed iddnt quite make sense. When i generated the combo's
underlying query i entered the format menu item to change colours and lines
etc of how it appears when displayed. but when displayed as the data source
for teh combo box it takes on the formats defined for teh combo box, how can
i change the format ie how the query is displayed when it is the source for a
combo box

pat
 
Top