CODEWITHSUNDEEP
ms-accessvba
Bruno
Bruno

Reputation: 6449

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: 2778

Answers (1)

Fionnuala
Fionnuala

Reputation: 91326

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