Optimize Access forms

[mygroup]

Hello Folks,

I have one Access application linked with SQL Server. There are few
forms loaded with lots of subforms and comboboxes. It takes 1 minute
or more to completely load one form. Is there any way I can optimize
these forms? There are some comboboxes which contains the same
information. Is there any way, I can store the values and then copy it
and use it for other comboboxes to populate? This way I might save the
time to fetch records from db. I fetched data in rst object and wrote
combobox1.Recordset = rst.Clone

but it does not seem working. Does anybody have any solid solution or
example?

Thanks.

 

[Golfinray]

I had very slow form problems. Our sql server was over in another building
and I was building forms local. I had the IT people put a directory for my
use on the server and load Access on it. They gave me a login so I could get
in. I copied my database to the server directory and now I'm not having to
wait on the server. Don't know if that helps any or not.