i have a form with several buttons to allow the user to sort the data, eg button 1 to sort by date.
i achieve this using:
Forms("Order Form").OrderBy = "Order.[Date]"
whenever i reopen the form, the form remembers the previous OrderBy and performs the sort. my question is how do i prevent the sort when the form opens?
i know i need to use the OrderByOn property of the form but i am not sure when to set this porperty. i have tried setting it on the onOpen event but that didn't work because the sort would have started already.