Sort Descending

[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.

 

[John Vinson]

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.

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.