how do I rank selections in a multivalue access field?

G

GenAMES

I want the order in which I select values in a multi-valued field to be
reflected in the order in which they're displayed, rather than being
displayed in the order in which they appear in the full range of available
selections such that the 1st item selected is the most important, the last
value selected is the least important etc.
 
K

KARL DEWEY

Not tried --
Have event of selecting to append records to a sort table that is joined in
your query. The sort table will need an autonumber field to sort on. You
will need to have a delete query run on the sort table on opening the form
(before selecting).
 
Top