Thanks everyone for your prompt replies on this. I used the built-ins...I hope that explains it properly...by using the built-ins I only ended up with this as far as code goes:
I'm assuming that the real code which drives this is embedded in the toolbar that's on this form. How I would read that to determine what order the sql statement is making to order the records is what I would like to ask.
Private Sub Table1BindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Table1BindingNavigatorSaveItem.Click
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Db1DataSet.Table1' table. You can move, or remove it, as needed.