Organising records

[fraser_lindsay]

This should be a simple one but I still can't manage it.

I have a table on which my records are organised in alphabetical order by one field.

On my form which uses this table as the record set the records are all over the place and it is a nightmare finding the record I want. I don't understand why it goes out of order in the form.

How do I make sure that they are organised using the same field?

 

[RuralGuy]

A Jet table is a bucket of records and Jet returns them in what "it" considers the most efficient manner. If you want some order to the records then you *must* use a query and specify the order.

 

[fraser_lindsay]

ok, so it wasn't a simple option I was missing.

Thanks for that.

 

[RuralGuy]

Now you know one of the many reasons you see recommendations to use queries all of the time.