Setting a combo box with most commoonly used entries first

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guys,

Is there any way you can set up the information in combo boxes so that (in a
network situation) you can display the most commonly used entries in a combo
box first for each user of the database??

Rather than just having the alphabetical listing of the information in a
combo box, the favourite selections have a priority for each user in a
network??

I don't know if this is possible ?

Can anyone help me??
 
You can create a query that sorts your data into whatever order you want,
and use that query as the rowsource for your combo box.
 
You can also create a field in your table (call is SortOrder) and then assign
specific numbers in that field to each record and then, as Doug has
suggested, have your query sort on the Sortorder field. This way you can
specify the exact placement of items in the list.

You will need some method for managing the sort order of the list so users
can move things within the list.

I use this method insituations where there may be a need to have certain
items to always be at the top or just to have a user defined sort order to a
list.
 
Back
Top