Drop down Popularity

[Jamo via AccessMonster.com]

Good afternoon,

I was wondering if there is a way you can order the options in a drop down
box by popularity i.e. the most commonly used option at the top.

Kind regards,
James

 

[Linq Adams via AccessMonster.com]

"most commonly used" as determined by what?

I suppose you could include a "ranking" field and sort on it, in the query
you're using as the basis for your combobox.

 

[Jamo via AccessMonster.com]

As determined by previous records. I guess I could create an additional
column counting the number of times each choice appears on my form, then sort
the dropdown by that ranking...

 

[Keith Wilby]

Good afternoon,

I was wondering if there is a way you can order the options in a drop down
box by popularity i.e. the most commonly used option at the top.

There's nothing built-in, you'd have to code it yourself. Doesn't sound
like a trivial task to me.

Keith.
www.keithwilby.co.uk

 

[Dorian]

Yes, you could certainly do that, you'd need an extra column for
'TimesSelected' which you would have to update on each selection and then
refresh your record source. You'd also have to have a SORT BY in your query
to sort on this column with DESC keyword to get the most popular first.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".