Sorting a Continous Form

[DS]

I'm trying to Sort a Continous Form on 2 Fields, MenuDay (Combobox) and
StartTime (Date/Time) field. I'm using the Order property on the form
and have entered such, but it doesn't work....

"MenuDay, StartTime ASC"

Any Suggestions?
Thanks
DS

 

[Rick Brandt]

I'm trying to Sort a Continous Form on 2 Fields, MenuDay (Combobox)
and StartTime (Date/Time) field. I'm using the Order property on the
form and have entered such, but it doesn't work....

"MenuDay, StartTime ASC"

Any Suggestions?
Thanks
DS

The OrderBy property is useless unless you also set the OrderByOn property
to True and guess what? That property is not shown in the property sheet and
has to be set via code. The easiest thing to do is to bind the form to a
query or SQL statement and set the order in that. Otherwise in the form's
Open event...

Me.OrderBy = "MenuDay, StartTime"
Me.OrderByOn = True

 

[DS]

The OrderBy property is useless unless you also set the OrderByOn property
to True and guess what? That property is not shown in the property sheet and
has to be set via code. The easiest thing to do is to bind the form to a
query or SQL statement and set the order in that. Otherwise in the form's
Open event...

Me.OrderBy = "MenuDay, StartTime"
Me.OrderByOn = True

Great, I took your advice and it worked fine.
Thank You.
DS