Sorting order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a table of 700 hundred people. ID number, first name, last name.
In the table, they are sorted by ID num, the primary key. When I pull the
form up,
the people are listed in order by the first letter of their first name. Z to
A.
Why is the form sorting diff from the table? Can this be changed?
Thank you all for your help.

Susan
 
Susan,

You can sort the form using the On Open Event:

Me.OrderBy="[Field1],[Field2], etc "
Me.OrdeByOn=True

Note: The OederBy id a string

Regards
Jacob
 
Is your form based on a query or directly on the table?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why can't I sort on the Column? 18
Sort based on the name selected under the combo box 14
sort in ascending order 4
Entering data with many to many relationship 1
Sort data based on sort from another table 5
datasheet: ¿how to order by the 2nd column of a combobox? 4
Sort Order in Tab page 1
Read Only Form 1

Back
Top