Order By isn't working

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have a continious form associated with a table.
I've entered into the Order By form's property the name of
the table's field (Table1.Field1) expecting that the data
in the form would be sorted by this field but it's not
working.

Could anybody clarify it?

Thanks
 
Hi Alex

What are you using as a recordset?

If it's a table you should look at indexing the field you wish sorted, or if
the recordset is a query then set the sort in the query.

Hope this helps

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
I have a continious form associated with a table.
I've entered into the Order By form's property the name of
the table's field (Table1.Field1) expecting that the data
in the form would be sorted by this field but it's not
working.

Could anybody clarify it?

Thanks
Click to expand...

You have to do it in code, probably when the form opens.

Me.OrderBy = "Field1"
Me.OrderByOn = True

- Jim
 
Back
Top