SubForm Sorting

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

Guest

My database is an employee listing showing name, building, room, phone, etc.
and I have a main form which indicates a particular organization and a
subform that lists all names, etc. assigned to that org. The subform also
has a combo box called "Status". "Status" has three choices: "E" for
employee, "C" for contractor, and "L" for laboratory. I want the "Status"
field to be alphabetically listed EXCEPT I want the Laboratories to fall at
the bottom of the list. Is there someway to sort the "Status" combo box to
alphabetize the "E" and "C" collectively and the "L" separately at the end?
Thanx
 
My database is an employee listing showing name, building, room, phone, etc.
and I have a main form which indicates a particular organization and a
subform that lists all names, etc. assigned to that org. The subform also
has a combo box called "Status". "Status" has three choices: "E" for
employee, "C" for contractor, and "L" for laboratory. I want the "Status"
field to be alphabetically listed EXCEPT I want the Laboratories to fall at
the bottom of the list. Is there someway to sort the "Status" combo box to
alphabetize the "E" and "C" collectively and the "L" separately at the end?
Thanx
Click to expand...
Am I missing something? "L" comes after "C" and "E".
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Correct. My problem is that I want "C" & "E" to be alphabetized as one
combination and then "L" to be alphabetized separately at the end of the
"C"&"E" list.
 
Back
Top