I set up a form that has 6 different combos that pull data from a database each time the form loads. I use the same recordset and connection for each combo. I just reopen the record set with a new sql statement for each combo. The problem is that it takes 6 seconds for the form to load. That may not seem bad, but the form is used alot and it gets annoying after a while. Does anyone have any suggestions to speed this process up? I'm using the Microsoft 4.0 jet engine too, which is supposed to be for Access 2000.
Thanks.
Tim
Thanks.
Tim