refresh subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have subform with as datasource a table.

I have a qeury to delete all records in the table.
And a query to fill the table.

After the update I do a "docmd.runcommand accmdrefreshpage"
The update of the table is OK, this is very quick

But the refresh of the form takes 10 seconds.

I also tried F9, this is also 10 seconds.


Is there a solution to make this faster?
 
Abrm,
Is the recordcount after the query the same as before? Does the form
load as slowly before you run the query? How many records are you
trying to refresh?

Also, I believe acCmdRefresh page is designed to refresh a Data Access
Page. You probably should use Requery.

Barry
 
Thanks for the reply.

It had nothing todo with the qeury behind the form.

In one of the other postings I found the solution.
I have a couple of comboboxes on my form with qeuries behind.
If I remove those, it is fast.

So I have found the problem, I only have to think of a soultion for my
datasources.
 
Back
Top