sort on open

[Guest]

I have a form that pulls table data and uses it as a sub form. It work very
well. I would like to sort that subform data so that it come up in numerical
order for 1 field. What is the best way to make this happen?

Thanks

 

[SusanV]

Use a query for the subform's record source, and sort that.

 

[Guest]

Thanks and have a great day!

Use a query for the subform's record source, and sort that.