Strange error, record has moved?

[bwian1234]

I have a db of 1900 clients, the Primery key is 'Client ref' which start on 0 up to 1900. (client ref 0 is blank)


The main form shows all the client details, when we load the form it defaults to record 0, we then use a search for what ever client we want. All has been fine.
I made a simple modification yesterday (just added a tick box) Now when you load the form it shows record 1 on the display at the very bottom of the form, but client 1801 is displayed.
When I scan through the clients it goes 1799, 1800, 1802,1803 and misses 1801, I have to go to record 1 to get to it.

How can this happen, and how do I fix it.
I need to move record 1 back to record 1801.

I have checked the Table and it all appears correct and in order.

I've never seen this before, can anyone help?

Thanks

[bwian1234]

Hmm, i've just re-booted the server. and now its working fine.
Strange, but sorted.

[pbaldy]

The order of records in a table shouldn't be relied on. I'd base the form on a query with the desired sorting.