Opening a Form hidden to populate in background

B

Benjamin

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?
 
M

Maurice

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...
 
B

Benjamin

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
 
Top