I get scrambled data on form.

[Julia82]

I have a database with a table and a form view. Now suddenly I see the
records in the database scrambled. The id's are not sorted ascending, but
scrambled. The same happends with the other records and I can't get them
sorted. I tried also to sort the table ascending, but didn't work.

Thank you!

 

[Roger Carlson]

Don't base your form directly on the table, but base them on a query which
is sorted the way you want. In the RecordSource property of the form (in
Design View), click the builder button [...] to the right. This will bring
up the Query Builder. Add all your fields to the query (or just the *) and
sort it the way you want. Then close the builder and save the form.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L