Order by

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

Guest

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?
 
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
 
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

finding record from autonumber field 7
SQL statement with LIKE need to show Numeric paceholders 1
Sort in VB using a ComboBox Column Other than the Bound Column 4
Text box Control Source in a form Question 1
I need help with the control source in a form 2
Sort records in a set of subforms 4
When I set the Orderby to true on my form access crashes by why? 1
Form: OrderBy minimum of fields 1

Back
Top