Alphabetical table

  • Thread starter Thread starter Jonah
  • Start date Start date
J

Jonah

I have a table which is sorted alphabetically but when I open my form which
takes all the details from this table the records are not in the same order
as the table.

The table was originally populated by someone else and I have alphabetically
sorted it but would like the form to show the records in the same order as
they appear on the table.

Is there any hope of me doing this or do i just shoot myself now?
 
You don't sort data in tables. Tables are used just to hold the data. Data
should be sorted using queries, forms and reports.
 
Thanks for the quick response Ronaldo, how do I sort the records that I have
into some sort of alphabetical order in the form?
 
The easiest way is to create a query from your table with the records sorted
as you want them and then base your form on the query instead of the table,
or put your sort in the order by property of the form.
e.g. TableName.FieldName
 
Back
Top