I get scrambled data on form.

I get scrambled data on form.

Post by SnVsaWE4M » Fri, 24 Apr 2009 17:44:01


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!
 
 
 

I get scrambled data on form.

Post by Roger Carl » Fri, 24 Apr 2009 23:52:29

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://www.yqcomputer.com/