My form has calculated fields that count from a query displayed as a subform. It's a crosstab query, so I display the query datasheet rather than a form because the column headings are not constant.
Anyway, I need to update the calc fields after the user applies a filter by using the context menu (right click). There is no event that is triggered for this, as far as I can see, because it is a query rather than a form. How can I .requery the calc field textboxes??