sort subform by text field

J

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!
 
R

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!
 
Top