How would you automate the sort ascend feature in a subform? I tried the orderby field in the properties section [fieldname]ASC but it doesnt work all the time is there another way?

thanks,
bob

You just need to enter the field name without the ASC as Acending is the standard sorting order DESC needs to be added if you want it the other way.

HTH

Mitch.