Sorting Form Problem

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

Guest

Hello All,

I have been pulling my hair out on a simple problem. Hoping someone here
has the anwer. I am trying to sort a field on a form by coding it's "on
open" property. The field is a combo box. Here is the code:

Me.OrderBy = "Occurrence ASC"
Me.OrderByOn = True


It appears to group the same words into groups. However, the entire list is
not sorted in ascending order. Any help would be appreciated.

Regards
L
 
Lowrider72 said:
Hello All,

I have been pulling my hair out on a simple problem. Hoping someone
here has the anwer. I am trying to sort a field on a form by coding
it's "on open" property. The field is a combo box. Here is the code:

Me.OrderBy = "Occurrence ASC"
Me.OrderByOn = True


It appears to group the same words into groups. However, the entire
list is not sorted in ascending order. Any help would be appreciated.

Could you give us a sample of what is not in order?
 
Back
Top