Order By isn't working

[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

 

[StCyrM]

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.

 

[Jim Allensworth]

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

 

[Alex]

Thanks a lot, Jim.

This approach is working.

Regards,

Alex