Insert data at the last line of table always made in MS Access

[billa856]

Hi,
This is the simple problem and I think it is the most easiest problem for experts working on this site.

I made one project in MS Access.
In that there is one form which i am using for data entry.
Also I have one table in which I have data like 6500 lines.
Now Whenever I use that form and click on submit button then data always go to the Line No 14.But instead of this I want that whenever I submit data it always must be enter at the last line of my table.

Reply me soon.

[billa856]

Now it is getting more weired data is going in any line.
plz help me

[HiTechCoach]

Are you going to a new record each time before you start entering data?

You can add a new record command button to your form or click the ">*" on the record navigation buttons (far right button)

[FishVal]

Hi, billa.

It looks like after submiting a record the form is required and the record appears on the place where it should be according to current sorting rule.

It would be nice to see

• the code behind "submit button click"
• metadate of the table where records are being added
• setting for the records' sorying in the form mentioned

Here is an example of how to post table MetaData :
Table Name=tblStudent

Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

Regards,
Fish