sort subform by text field

  • Thread starter Thread starter JohnLute
  • Start date Start date
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!
 
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!
 
Back
Top