Order data on a form

[Chunk]

I want to order the data on a tabular form.

I realise I could do it by basing the form on a query like:

Select *
from table
order by field

But I have allready made andlaid out the form, after basing it just on the table. Is there a way I can now order the data on the form, after having created it?

 

[Rich]

There's no reason why you can't easily switch the record source of your form to a query

 

[Chunk]

Ill give it a try.