As innocuous as these 4 statements might seem, if they're inserted into the OnOpen procedure the app "blows up". As soon as I moved them to the OnLoad procedure everything worked as expected.
Code:
SortColumn = "lblTDate" 'This will change per user selects
Highlight (SortColumn) 'Highlight column label as currently sorted
SortField = "tbTDate" 'Need the control name for the Company
Me.OrderBy = "TDate"
Before I ever posted this issue, I ran the app in debug mode in attempting to find the point of failure by stepping through the code. I still don't know what caused Access problems, but perhaps it had something to do with text boxes in the footing whose ControlSource properties involved aggregate functions.
Thanks for all the thoughts,
Bill