W
Wolfram Oldörp
Hi group,
Access 2002, SQL-Server 2000
I have a mainform with a subform. Mainform is bound to a view for some order
data.
Subform is bound to a stored procedure. The parameter for the procedure are
changed in mainform current event.
On the mainform are comboboxes to choose an order. For this purpose the
allowedits is temporarily set to true, in gotfocus event of the combobox
(and false in lost focus). Allowedits only changes for the mainform, not for
the subform.
With profiler I can watch, that the adp requeries the procedure of the
subform, when allowedits of the mainform changes from false to true.
The procedure is a complex crosstab, so the user has to wait every time,
after he moves to one of the comboboxes.
Definitely this requery is not from VBA.
Setting the subform to snapshot does not change the behaviour.
How can we force the adp not to requery the subform ?
regards
Wolfram
Access 2002, SQL-Server 2000
I have a mainform with a subform. Mainform is bound to a view for some order
data.
Subform is bound to a stored procedure. The parameter for the procedure are
changed in mainform current event.
On the mainform are comboboxes to choose an order. For this purpose the
allowedits is temporarily set to true, in gotfocus event of the combobox
(and false in lost focus). Allowedits only changes for the mainform, not for
the subform.
With profiler I can watch, that the adp requeries the procedure of the
subform, when allowedits of the mainform changes from false to true.
The procedure is a complex crosstab, so the user has to wait every time,
after he moves to one of the comboboxes.
Definitely this requery is not from VBA.
Setting the subform to snapshot does not change the behaviour.
How can we force the adp not to requery the subform ?
regards
Wolfram