A Angelsnecropolis Nov 4, 2009 #1 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.
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.
G Gina Whipp Nov 4, 2009 #2 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
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
