Order By isn't working

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

On Thu, 19 Aug 2004 12:28:53 -0700, "Alex"
wrote:

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

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

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

- Jim

Thanks a lot, Jim.

This approach is working.

Regards,

Alex
-----Original Message-----
On Thu, 19 Aug 2004 12:28:53 -0700, "Alex"
wrote:

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

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

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

- Jim
.