I have a form where I specify information that is used by a subform in tabular view. The subform then displays entries for the item specified in the main form. Each entry has a date associated with it. I would like the entries to show up sorted by date such that the latest dates are at the bottom, and when you add an entry in the subform (supposedly with today's date) it appears where it needs to be. Of course, when you view a different item and then come back to this item, I would like the sort to put the new item in its appropriate, sorted spot (just in case the new item has an earlier date than any already in the database).
In a nutshell: How do I specify a sort criteria for a tabular form?
If you add records to the subform, you'll need to requery and refresh the form.