Sorting not working on Form

S

Smiley

Have a query which is display in order as expected. However when using the
query in a form which data showed as the sequence of data input NOT as how
it is showed in query.

What need to be done to have it list as in query.

I have tried the order by but there is no effect.
 
J

Jeff Boyce

Are you working with a form or a report?

When I create a form based on a query, the form displays the data in the
sort order given by the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
L

Linq Adams via AccessMonster.com

Are you saying that when the form first opens, the records are not in the
same order as they appear in the query, or that after adding records they're
not sorted? After adding new records thru a form, the form must be requeried
(Me.Requery) before the sort order will be correct. The other thing I'd do is
check the RecordSource for your form again, to make sure that it's the Query
and not the underlying Table. Using the Table without doing anything else
would yield the exact results you list.
 
Top