Scrambled data

[Julia82]

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.

 

[Noëlla Gabriël]

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 .

 

[BruceM]

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.

 

[Julia82]

Big kiss both of you! You made my day!

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