Scrolling Access 2000

[Neale]

I have an annoying problem with Access 2000.

I have a simple database and i am using a form.
When i scroll through the entries using the arrows that appear at the bottom of the screen the records don't move in numerical order. they seem to move from one record to the next based on one of the fields. i want this scrolling to be based on the primary key, which is a job number. I don't know how to change this however.
Currently the scrolling moves based on a field that only has two variations, therefore you click next and it goes to record #1000, then #299, then #400, etc.

I realise this is very obscure but if anyone has any suggestions i would be grateful and could always email screenshots if that is helpful.

 

[GVaught]

Is the primary key text only, alphanumerical or numerical? Generally, the
order of a table is determined by the primary key value. If you need to view
the records in another order create a query with all the fields and set the
sorting to whatever field and then attach this query against your form.

I have an annoying problem with Access 2000.

I have a simple database and i am using a form.
When i scroll through the entries using the arrows that appear at the

bottom of the screen the records don't move in numerical order. they seem to
move from one record to the next based on one of the fields. i want this
scrolling to be based on the primary key, which is a job number. I don't
know how to change this however.

Currently the scrolling moves based on a field that only has two

variations, therefore you click next and it goes to record #1000, then #299,
then #400, etc.

I realise this is very obscure but if anyone has any suggestions i would

be grateful and could always email screenshots if that is helpful.