Here I sit, broken hearted...... wrong forum.
OK, I added a new record to a data table in a form. Everything is cool. All the information is in the right field and in the Access database the new record is last, as it should be. However (why is there always a however?), for some reason, the added record always shows up in the data grid view and in the binding navigator, in another form, as the first record, instead of the last. What's going on here?