Sort order in a sub form

[roar58]

Hi!
I have a subform with records from a table. I want the records in a certain sort order when I open the subform. If I will sort a true/untrue field, then it sorts the true fields first. But if I want to sort by a field with values, it starts with the records with no value, and then comes the values in no particularly sort order. Let's say that I have the values 1,2 and 3 in the field and will sort the records in that order. What would be the expression in the sort order property (or arrange by property) (I have a Norwegian version of Access) in the form control? Let's say the field has the name [status].
Greetings from Roar58

[June7]

Don't really understand your issue. Sorting is fairly easy and straightforward.

Sort is defined with the ORDER BY clause of query or the ORDER BY property of the form.

In query would be: ORDER BY [Status]
or
ORDER BY [Status] DESC

In ORDER BY property, simply: [Status]
or
[Status] DESC