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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form with Subform not Refreshing 1
Which is faster? 6
Access Form Refresh 1
Access Daily Entry with multiple entries per field 0
Using form and subform not connecting to two separate tables 0
Using an append query in a subform 1
Use field to update multiple fields 4
Subform Refreshing! 1

Back
Top