ComboBox - Keep Original Drop Down Order

  • Thread starter Thread starter Jado
  • Start date Start date
J

Jado

Hi

I want to create some automated graphs in Excel 97 using values from a combo
box in Access 97.

if I base my chart on an Access Group query....

the query re arranges the order of the dropdown values into alphabetical
order.

this messes up the look of the resulting chart!

does anyone know how you might work around this?

Thanks

Jado
 
Hi:

You can add a ID column (Long Integer) and also group on that field (group
first on this ID field and then the other field). Enter ID values in the
order you want them to appear on the chart.

Regards,

Naresh
 
Hi

my combo's are all using Value Lists RowSource

is what your suggesting still possible using this method??

Thanks Jado
 
Back
Top