Order By Problem

[Guest]

I'm attempting to Sort the records on my form. I'm using the Order By and
typing in:
MainCustomer.MainCustomerID DESC

The MainCustomer is my corresponding table to the form and the
MainCustomerID the field I would like my records sorted by. It is not
working. Does the field you are sorting have to be the first field in the
tab order/table, etc.? I believe this is the correct format as I have it,
but I guess not because it will not sort correcty. It sorts as if there were
no Order By field. Also, I have a Subform on my form, does this matter?

 

[fredg]

I'm attempting to Sort the records on my form. I'm using the Order By and
typing in:
MainCustomer.MainCustomerID DESC

The MainCustomer is my corresponding table to the form and the
MainCustomerID the field I would like my records sorted by. It is not
working. Does the field you are sorting have to be the first field in the
tab order/table, etc.? I believe this is the correct format as I have it,
but I guess not because it will not sort correcty. It sorts as if there were
no Order By field. Also, I have a Subform on my form, does this matter?

The OrderBy property doesn't take effect until you set the OrderByOn
property to Yes.
Right-Click on an empty spot on the form.
Select "Apply Filter/Sort"
To go back to your original sort, select "Remove Filter/Sort".

A simple method to change sort order in a form is to select the field
you wish to sort by (in Form View) on and then click the A-Z or Z-A
tool button.

 

[Guest]

THANKS I was fooling around in design view the entire time