Form OrderBy Asking for Parameter

[avalentini]

Hello,

I have a form with several subforms whose records I am attempting to display as according to the OrderBy property. I first tried doing this using the Property Sheet, setting the respective Order By properties to "fieldName". Then, I tried using the following code:

Private Sub Form_Current()

    Me.OrderByOn = True
    Me.OrderBy = "media_PublicationDate DESC"


End Sub

In both cases, the records were ordered, but the form requested that I first enter a parameter before accessing it. I assume that this parameter is sort of starting point from which the records are then ordered? Is there any way to order forms and subforms without having to deal with this prompt?

Thanks

[orange]

What is the recordsource of the form? You might try a query with the Order BY as part of the query.

[avalentini]

The recordsource is a table - same with the subforms.

Any idea why it is asking for a parameter? Is this normal with OrderBy?

[orange]

Sometimes, Access asks for a parameter because of a spelling mistake.
Tell us about your tables and the form and subforms.

[avalentini]

Sometimes, Access asks for a parameter because of a spelling mistake.

. . . it was a spelling mistake.

Thanks for the simple solution!

[orange]

Been there! Happy to help.