This has been superceeded by another issue... please see http://www.access-programmers.co.uk/forums/showthread.php?p=1126865#post1126865
thanks
HI
Would appreciate advice on the following please.
I have a Main form with several subforms (6 all told, each on its own tab). Once loaded they very 'static'. They are ADO based and just grab records from a table using a SELECT in the ADO source. I update their filters from the main current event (to replicate Master/Child links).
Because my main is also ADO based, Adds/Edits and Deletes are picked up by it by resetting its recordset (not requery as inDAO)... so...
Set me.form.recordset = me.form.recordset
At this point, Access trundles off, unloads and re-opens all the subforms.... this obviously takes some time.
I am considering cancelling (cancel=vbtrue) in all the subform unload events... (using a flag to ensure this is done appropriately)
Do you think this cancelling is wise or should I just accept the amount of time it takes to refresh everything please?
Thnx
thanks
HI
Would appreciate advice on the following please.
I have a Main form with several subforms (6 all told, each on its own tab). Once loaded they very 'static'. They are ADO based and just grab records from a table using a SELECT in the ADO source. I update their filters from the main current event (to replicate Master/Child links).
Because my main is also ADO based, Adds/Edits and Deletes are picked up by it by resetting its recordset (not requery as inDAO)... so...
Set me.form.recordset = me.form.recordset
At this point, Access trundles off, unloads and re-opens all the subforms.... this obviously takes some time.
I am considering cancelling (cancel=vbtrue) in all the subform unload events... (using a flag to ensure this is done appropriately)
Do you think this cancelling is wise or should I just accept the amount of time it takes to refresh everything please?
Thnx
Last edited:
