Sorting values in a lookup list

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

I am using a lookup list in a form . This list
is "Initial, 3 mos, 6 mos, 1 year, 2 years). I used this
field to indicate when I contact a person as part of a
follow-up survey. I would like for this column to sort
itself according to the order above whenever I go to a
particular record.

Thank you in advance.
 
Ellen,

Add a SortOrder field to the lookup table and put values
in it that will guarantee the sort in the order you want.

HTH
Dale
 
Back
Top