Sorting a Continous Form

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
DS said:
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
Click to expand...

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
 
Rick said:
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
Click to expand...
Great, I took your advice and it worked fine.
Thank You.
DS
 
Back
Top