CODEWITHSUNDEEP
ms-accessvba
Bruno
Bruno

Reputation: 6459

MSAccess VBA sort query by ascending

I have the following query:

DoCmd.OpenForm "BPRIL Data Entry", , , "[Deleted]<>-1 Or [Deleted] Is Null", acFormEdit, , ""

How do I sort by ascending. I know it's something like ORDER BY ASC but I don't know where to place it.

Upvotes: 0

Views: 2780

Answers (1)

Fionnuala
Fionnuala

Reputation: 91376

You can use properties of the form once it is open:

Forms![BPRIL Data Entry].OrderBy = "Something"
Forms![BPRIL Data Entry].OrderByOn = True

Ascending is the default.

Upvotes: 1

Related Questions