Form Not Sorting!!

[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

 

[Guest]

Try this:
Me.OrderBy = MyRecordSet![Occurrence ASC]
This assumes Occurrence ASC is a field in your recordset. By the way,
spaces in names is always a bad idea. Consider OccurrenceASC or
Occurrence_ASC

 

[Guest]

Ok I tried that and it gave me an error saying MyRecordSet not
defined...Also, there is no sace...Occurrence is the control source and ASC
is the sort order...

Try this:
Me.OrderBy = MyRecordSet![Occurrence ASC]
This assumes Occurrence ASC is a field in your recordset. By the way,
spaces in names is always a bad idea. Consider OccurrenceASC or
Occurrence_ASC

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

 

[Guest]

MyRecordset should be the name of your record source (table or query).

Me.OrderBy = MyRecordSet![Occurrence]
You don't need the ASC that is the default. If you want descending, then
you would use DESC.

Ok I tried that and it gave me an error saying MyRecordSet not
defined...Also, there is no sace...Occurrence is the control source and ASC
is the sort order...

Try this:
Me.OrderBy = MyRecordSet![Occurrence ASC]
This assumes Occurrence ASC is a field in your recordset. By the way,
spaces in names is always a bad idea. Consider OccurrenceASC or
Occurrence_ASC

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