Scrambled data

Scrambled data

Post by SnVsaWE4M » Tue, 28 Apr 2009 15:35:01


I have a table with data and a form to display the data and where I input the
data also. Somehow these days the data got scrambled, meaning that the
records are not displaied in the form as I input them the first time.
I tryed to sort the table, to delete ID, but didn't work.
Thank you very much.
 
 
 

Scrambled data

Post by Tm/Dq2xsYS » Tue, 28 Apr 2009 20:05:01

Hi Julia,

in the forms design view you can use the form property "Order By" to set the
data order to the field(s) you want the data sorted by .
--
Kind regards
No毛lla

 
 
 

Scrambled data

Post by Bruce » Wed, 29 Apr 2009 00:56:08

In general it is best to use a query as the Record Source for a form or
report, as you can sort the records and otherwise manipulate them (for
instance, combine FirstName and LastName, or perform calcualtions) to suit
your needs. In any case, a table should not be thought of as being in any
particular order. That's what queries are for.

You can use the form's Order By property, as suggested, but the query gives
you a lot of flexibility.
 
 
 

Scrambled data

Post by SnVsaWE4M » Wed, 29 Apr 2009 02:56:01

Big kiss both of you! You made my day!

It was simple in fact. "Order by" property did the job.