Hi
In VBA I populate an unbound subform (datasheet view) via a recordset that can be changed using filters selected by the user. The only problem I am having is that due to the unbound nature of the subform the sorting function activated by the column header click only works once, the second time the user tries a sort an error occurs ("Data provider could not be initialized").
Is there any way I could handle the column header click in code and resubmit a recordset based on which column they have clicked on? I can't seem to find an event for this where access knows that the header has been clicked.
Thanks in advance
In VBA I populate an unbound subform (datasheet view) via a recordset that can be changed using filters selected by the user. The only problem I am having is that due to the unbound nature of the subform the sorting function activated by the column header click only works once, the second time the user tries a sort an error occurs ("Data provider could not be initialized").
Is there any way I could handle the column header click in code and resubmit a recordset based on which column they have clicked on? I can't seem to find an event for this where access knows that the header has been clicked.
Thanks in advance