Sort by ascending on event

[Angelsnecropolis]

I need a code or some method to auto sort by ascending for a txt box called
txtDate on form load or on a button click.

Thank you.

 

[Gina Whipp]

Angelsnecropolis,

On_Click of your button put...

Me.txtDate.SetFocus
DoCmd.RunCommand acCmdSortAscending

As a side note, if you have named the underlining field Date then you should
review this page... http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm