Form Refresh

[ghacig]

Dear All

I have a large from that contains several subforms and listboxes. The subforms are linked to the main form (Master-child link). The purpose of the form is to display various data when the user logs on. Everything works well except that every time a command is run, all the subforms get re-queried automatically, which slows down the response. For example, there is a command that filters one of the listboxes. The list box is unrelated to the subforms. When the command is activated, all the subforms 'blink' like they are being re-queried. Is there any reason for that and can I stop it because it does slow does the response time.

Thank you for any help.

 

[Andrzejek]

I am lost here.
If : “every time a command is run, all the subforms get re-queried automatically, which slows down the response.”, then if “The list box is unrelated to the subforms” why do you re-query all the subforms?
“Is there any reason for that” well, do you have any reason to do that? You should have the answer. And the answer is No.
“can I stop it” Yes, and you should. “because it does slow does the response time” well, yes, obviously.

So, what was the question again….


Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[ghacig]

Hello Andy

Thank you for responding. I don't think I was clear. The code does not include a command to re-query the subforms. The code is to filter the listbox. However, when the command to filter the listbox is activated, all the subforms get re-queried for no obvious reason.

 

[Andrzejek]

Step thru your code and see which line of code makes the subforms to get re-queried

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.