-
Mar 6th, 2015, 11:43 AM
#1
Thread Starter
Fanatic Member
[RESOLVED] data table display order
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?
-
Mar 6th, 2015, 01:57 PM
#2
Thread Starter
Fanatic Member
Re: data table display order
I did find and correct the problem. It turns out that the order property in the binding navigator had no value. I input the name of the field by which I wanted the records ordered and that fixed the problem. The question that leaves me with is why was this property blank in the first place? In previous usage of the binding navigator I never encountered this problem.
-
Mar 6th, 2015, 09:07 PM
#3
Re: [RESOLVED] data table display order
It was blank because how could it possibly know what field you did want to sort on? As for comparing it to your previous usage... maybe you got lucky... maybe it was set at some point. With out any sorting, it's simply going to display the records in the order they're in the datatable which likely depends on the order in which they were retrieved from the database which depends on a number of factors.
-tg
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|