Sorting Form Problem

[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

 

[Joseph Meehan]

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?