Sort Descending

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

How can I make a subform display records in descending
order automatically when the subform is opened. I tried
entering in the subform property Orderby "submisiondate
DESC" but a parameter box pops up when I open the
subform. It also does it with I tried it in the table for
the subform.

The subform record source is linked directly to the table.
 
How can I make a subform display records in descending
order automatically when the subform is opened. I tried
entering in the subform property Orderby "submisiondate
DESC" but a parameter box pops up when I open the
subform. It also does it with I tried it in the table for
the subform.

The subform record source is linked directly to the table.
Click to expand...

Link the subform instead to a sorted Query. The query will be
updateable (and will update the table) if you don't do anything else
than sort it.
 
Back
Top