[AccessD] Slow Forms

...have you tried not loading the tabbed data until its actually selected
...that should let your main form open quickly based upon the info you
submitted.

William Hindman
ipsedixitism: something is true because I myself have said it is true ...the
philosophy of Noam Chomsky :)

----- Original Message ----- 
From: "Reuben Cummings" <reuben at gfconsultants.com>
To: "AccessD" <accessd at databaseadvisors.com>
Sent: Tuesday, March 30, 2004 4:14 PM
Subject: [AccessD] Slow Forms


> I need help with a form that opens very slowly.
>
> Everything worked very quickly until I compacted and repaired the db.
After
> compacting, this form will open slowly one time and then open quickly all
> other times.  It will continue to open as I would expect it to until it is
> compacted again.
>
> However, if the app is made into an mde then it always opens slowly.
>
> The form is based on a query.  There is a tab control on it.  One tab has
> about 14 fields from the same recordsource as the main form.  The other
> three tabs all have subforms based on queries.  2 of those queries have
> fields that call functions to get their value.
>
> All the queries and subforms open very quickly.  And if I delete the
> subforms, the main form will always operate quickly.
>
> I have imported into new db's.  I have completely rebuilt the main form.
>
> Any suggestions on where to start troubleshooting this thing?
>
> Thanks.
>
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.com
>
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>