Opening a Form hidden to populate in background

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

Guest

I have created a form from 2 tables linking using SQL. This form needs to
display 30,000 records, so in order to speed this up I tried opening it
hidden while logging on hoping it would be fully populated when I need it.
But it runs slower than opening it normally, any ideas?
 
Don't know but just out of curiosity why would you want a form to display
30.000 records anyway?

As you mentiond the hidden option doesn't make it faster. The only thing
that will make it faster is to get 'chunks' of data you really need. So think
query and parameters. That will speed up things for you...
 
Cheers Maurice, I know hidden option doesn't make it faster, but I'm opening
the form well in advance of when I want to look at it, but it still not
populated, wondered if it was like windows prioritising applications that are
in focus

30,000 records! I know it's silly but the users like to use it as a last
resort when searching
 
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

Continuous Form - Populate unbounded field 1
Opening form unexpectedly closes other form 0
hidden forms 3
Separate Form 0
Listbox to a form 5
Populate a form based on a query using parameters 8
Having Trouble creating a hidden form (A2003) 4
Open a form in hidden view 2

Back
Top