Order by

W

WoodyAccess

My form has OrderID as its PK (which is not-visible in my form) but I want my
form to Order by "PurchaseOrderNumber". I have tried typing
[PurchaseOrderNumber] into the Form, Properties, Data tab, OrderBy section
but it still does not sort by number.

How can I make this sort by this number field?
 
K

Keith Wilby

WoodyAccess said:
My form has OrderID as its PK (which is not-visible in my form) but I want
my
form to Order by "PurchaseOrderNumber". I have tried typing
[PurchaseOrderNumber] into the Form, Properties, Data tab, OrderBy section
but it still does not sort by number.

How can I make this sort by this number field?
Click to expand...

Base your form on a query with the table as it's source. You can then sort
of as many fields as you like.

HTH - Keith.
www.keithwilby.com
 
Top