sort subform by text field

[JohnLute]

I have a subform with [Category] as a text field combobox with 3 possible
values:
Unit
Case
UnitLoad

I'd like to sort the subform in the above order. I believe this can be done
with a "Right" code order in the subform's underlying query...?

Thanks in advance!

 

[Rui]

Open the subform. Select the form record source and edit it with the query
buider.
Add the desired sort order just as you specified.
Close the query builder.

That's it!