how to sort fields in a subform

  • Thread starter A.J.M. van Rijthoven
  • Start date
A

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??
 
O

Ofer

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