Does anybody know how get the sort feature on a subform to work? When i view the subform indepentantly, the sort is correct. However, when I open the main form, the subform sort is incorrect. Any ideas?

Thanks.

If your subform is based on a query, have you set the orderby in the query?

HTH,
Loralee

After reading the above response. I tried this with a query. I was having trouble getting the subform to work. However, after establshing a relationship between the table and query in the relationships, I was able to get this to work. Thanks for the suggestion.