Disable Sorting on a Continuous Form
Posted on 2006-05-11
I have a main Form, with a Subform on it. The subform shows Transactions, which are calculated to acheive a running balance. If a user right clicks, and sorts this form, the calculations are not correct.
How can I disallow sorting on this form? I do want to sort data on the main form, just not on the subform.
From what I see, a user can click a record on the subform, and use the toolbar at the top of the screen to sort, or a user can right click a field and sort ascending/descending.
I need to disable both methods for the continuous subform.
Thanks! - AB