Are you doing this over a LAN, or over a WAN?

Is your form bound directly to the table, or to a query? And to how many
rows?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"jenniferspnc" wrote in message
...
Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties
of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!