Sorting on forms?

[kbrooks]

This seems like a really silly question to me but I can't figure it out. I know how to sort on a report...but is it possible to sort on a form?

I have a form that lists one record per line. I want to be able to sort them by a date field named DateOfService to make things easier to find for the user. Is this possible?

Thanks!

 

[Chris RR]

Here are two options. Either base your report on a query, and sort the records there, or use the "orderby" option on the form properties.

 

[kbrooks]

You can base a form on a query? I was thinking that was just for reports. Have to give that a try.

I tried the orderby on the form properties but it didn't seem to do anything.

Will give this first suggestion a shot...thanks!