ComboBox - Keep Original Drop Down Order

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
 
N

Naresh Nichani MVP

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
 
J

Jado

Hi

my combo's are all using Value Lists RowSource

is what your suggesting still possible using this method??

Thanks Jado
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top