Sorting order

S

Susan

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
 
J

Jacob

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
 
Top