subform orderby

[kadams0920]

Hi, I'm trying to order a subform by a date in descending order, so I used the orderby property of the form like this: "DateServed Desc". This then doesn't seem to translate when the form is a subform of another. It's not ordering as specified. Do I need to do something additional in the subform to get it to order the way I want it to?

Also, what is the best way to check for the most current date on the same form and produce a warning (in an unbound text box?) if the last date is not 14 days or greater than today's date?

Thanks for your help.

 

[kadams0920]

SOLVED: Re: subform orderby

I figured this out by invoking a query and sorting there.