Sorting a Subform

  • Thread starter Thread starter Keith
  • Start date Start date
K

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
 
You could make the Record Source of your subform a query which can contain
an ORDER BY clause.
 
Keith said:
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
Click to expand...


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

hth

Hugh
 
Back
Top