how to sort fields in a subform

[A.J.M. van Rijthoven]

I have a form and a subform that are linked to each other.
Master fields=netID (form)
Child fields = netID (subform)
I filled in : Lookup_Instrumenten.Instrumentnaam at the form
propertys of the subform.
the fields in the subforn however are not sorted alfabetically
How do I achieve this??

 

[Guest]

Go to your subform recordsource and sort it by any fields you want.
Incase you just specified a table in the su form recordsource then go into
the sql and create a sql "select * form table order by Field1, Field2"