How can I refresh a form without refreshing the subforms that are contained on it?
Posted on 2009-04-12
Is it possible to refresh a form without refreshing the subforms contained on it? Basically, when I requery or refresh my form the subforms blink once as if they are refreshing. I do not need this to happen as the subforms are only on there for extra information and not part of the same record, i.e. the subform information is static and the recordsource is from another table. Please could somebody help me to not refresh these subforms?
At the moment, on my form that has the subforms on it, I click a button to refresh the data on the form, in effect this refresh saves the data to the table. When I click this button the subforms blink as if they are updating, but this is not required.
I have tried both me.refresh and me.requiry but neither have stopped the subforms from blinking once.
Any help would be gratefully received. Thank you.