Sorting a Subform

[Keith]

Hi All

I have a subform in my DB (subform is in Continuos Forms view to produce a
list). How do I make it so that this subform list is always sorted in a
particular order?

I tried setting the Order By but it didn't work - maybe it was just the way
I set it up.

Help please.

Keith

 

[Cheryl Fischer]

You could make the Record Source of your subform a query which can contain
an ORDER BY clause.

 

[Hugh O'Neill]

Hi All

I have a subform in my DB (subform is in Continuos Forms view to
produce a list). How do I make it so that this subform list is
always sorted in a particular order?

I tried setting the Order By but it didn't work - maybe it was just
the way I set it up.

Help please.

Keith

After using the OrderBy, did you also set OrderBy On? It's a two stage
process.

hth

Hugh