Hi
Set up a query, set your sort order in there and then change the control source on your form to the query

There is an Order By Property in the property sheet, or you could set the Record Source to an SQL statement with an Order By clause.

Seems a revisit of the courses and the TechHelp may be in order.  That is the beauty of video.  You can watch more than once.  ( or if you are like me 10 times :-)  )

If you check out the Access Index
and type Ctrl-F a search for SORT produces 104 matches.  ORDER BY produces another 16 matches.
The one in Expert 3 looks like it might be of real use to you.

I can't find it right off the top but there was a video where Richard showed how to use the label in a continuous form to sort the records.  It might have been the Search Form 2.0 video.

Scott Was it the Payables Seminar you were thinking of?

Kevin I missed that one.

Richard has covered this many times.  Here is what I've found it in addition to the one you listed
:
ABCD4

Search Seminar

Developer 26

Check Register Seminar

Changing the Order By property of the form should do it. Or a query like Dan suggested. Or the other stuff the guys said. Lots of good options here. More than one way to skin a cat. :)