"Order By" in form properties

  • Thread starter Thread starter CEV
  • Start date Start date
C

CEV

I am having trouble getting this to work. I have a current form that states
"[Individuals].[Last Name]" in the "Order By" field of the form properties
and it works as it should. I have created a different form and am trying to
do the same thing but it will not work. In this new form I have it list
everyones name with a checkbox to the right of it. They are automatically
ordered by the persons Social Security number and I am trying to get it to
order by the last name. The [Individuals] represents the table and the [Last
Name] represents the field that contains the persons last name. What I am
doing wrong and what else can I try?

Thank You,

CEV
 
I am having trouble getting this to work. I have a current form that states
"[Individuals].[Last Name]" in the "Order By" field of the form properties
and it works as it should. I have created a different form and am trying to
do the same thing but it will not work. In this new form I have it list
everyones name with a checkbox to the right of it. They are automatically
ordered by the persons Social Security number and I am trying to get it to
order by the last name. The [Individuals] represents the table and the [Last
Name] represents the field that contains the persons last name. What I am
doing wrong and what else can I try?

Thank You,

CEV
Click to expand...

After you wrote [Individuals].[LastName] in the Order By property line
did you then set the OrderByOn?
In Form view, right-click on the form and select Apply filter/sort.
 
I am having trouble getting this to work. I have a current form that states
"[Individuals].[Last Name]" in the "Order By" field of the form properties
and it works as it should. I have created a different form and am trying to
do the same thing but it will not work. In this new form I have it list
everyones name with a checkbox to the right of it. They are automatically
ordered by the persons Social Security number and I am trying to get it to
order by the last name. The [Individuals] represents the table and the [Last
Name] represents the field that contains the persons last name. What I am
doing wrong and what else can I try?
Click to expand...

It's rather hard to tell what you're doing wrong because you don't
really say what you ARE doing.

The Form's OrderByOn property should be set to Yes (otherwise it will
ignore the OrderBy); and the form's Recordsource must include the
LastName field from Individuals, not just a lookup to that field.
Other than that - please post the form's Recordsource and the relevant
form properties.

Just FWIW I'd be inclined to simply base the form on a Query sorted as
you wish to see the data, rather than using the OrderBy.

John W. Vinson[MVP]
 
That was it. It was already set, but I removed it and then reapplied and it
worked after that. Thanks for the information.

CEV
 
Back
Top