I have a form that displays a single record from a table in a dataset. Like most forms of this type I have a binding navigator on the form. There are no problems with the binding navigator until I add a record to the table. What occurs is this.
If the binding navigator is located at the last record and I add a new record to the table then the binding navigator will show that record as the last record (which is the expected behavior). However, if I have the binding navigator located at the first record and add a new record then the binding navigator will show the new record as the first record. Additionally, I have another form that has a datagrid view and it appears to mirror what the binding navigator shows, with regard to the location of the new record. I checked the table in the database and the record is located at the bottom of the table as it should be.
It appears to me that I have some kind of indexing issue, and I have looked at the properties of the binding navigator and can see nothing that would do anything for this. Perhaps someone might explain to me what I am doing wrong here.