I have a main form contains subform control that is related to the a form based on a crosstab query. The crosstab query column header and its records are inserted by the user at run time.
To show the newly added column header records on the right hand side of the subform, I set its soruceobject, which works well to display the runtime added records.
But the screen.activecontrol failed to catch the clicked column header name even with requery, refresh or repaint used. Since user may click an existing column header to make a copy of its header and its value records. Without a way to detect which column is clicked, there is no way to make copy of the records insert into the database.
The activecontrol only works for the initial queried column header clicking, not dynamically created crosstab query subform datasheet.
I am doing the prototype now. Company still uses MS Access 2002.
Any help would be appretiated.
John
To show the newly added column header records on the right hand side of the subform, I set its soruceobject, which works well to display the runtime added records.
But the screen.activecontrol failed to catch the clicked column header name even with requery, refresh or repaint used. Since user may click an existing column header to make a copy of its header and its value records. Without a way to detect which column is clicked, there is no way to make copy of the records insert into the database.
The activecontrol only works for the initial queried column header clicking, not dynamically created crosstab query subform datasheet.
I am doing the prototype now. Company still uses MS Access 2002.
Any help would be appretiated.
John