In the starting I thought there is some problme in my VB Coding, I debugged it a lot but to no results.
Suddenly I thought let me try entering Rows from MS-SQL Enterprise Manager only before looking into the VB Module Code.
In my Database Table, there is no primary field, all fields Allow Nulls is checked. Table consists of 18 fields of char,varchar, date etc.
After Moving to the last row, When I enter Records say 3 at a go and then closes the table and again open it I found that that out of three, 2 are placed in between and 1 in the last.
It is happening everytime and whatever I enter, sometimes 1 is placed in the last, 1 is placed somewhere and another 3rd somewhere else.
I have nothing as such defined on the table. According to me it should be like the records should come the way I am entering, the order should be like this only.
Why this is happening, please tell, if you have any ideas.