Adding new record

[mikki]

When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?

[parksie]

Have a look at AddNew, but in your case, I would advise that you don't need to put it in a specific order in the table. Just re-order it when you SELECT the records.

[JHausmann]

Originally posted by mikki
When adding a new record to database table, the record is added in the very first position and at the end of the table. How do stop writing over the first record in the table?

I'll bet you don't have a primary key defined...

[mikki]

My primary is ClientID