Form with subforms very slow to load

J

John A.

Hi all -

My app has a form with two subforms. Main form is bound to a table, both
subforms are bound to a different, but related table. One of the subforms
acts as a list of items from which the user picks one to edit the details.
The "edit details" subform LinkMasterField is a control on the MainForm
whose control source is
=[WinList].[Form]![ID]
where WinList is the other subform.

Here's my issue - this form takes a long time to open, 20-30 seconds
depending on the number of users. In opening for the first time, or from
Design view, the "On Current" procedure of one subform runs 8 times (other
subform doesn't have an "on current" procedure).

Is there any way to cut down the number of times that event fires, or is
that just a result of the way the forms and subforms load up and link?

Thanks in advance,

John

btw - running in Access2000 on Windows2000 Terminal Server. Been up and
running for years.
 
L

Linq Adams via AccessMonster.com

Since the Form_Current event only fires when navigation occurs from one
record to another, this really makes no sense! IT should fire once when a
form is loaded. I guess we need to see the code for your Form_Current event,
snd probably the FormOpen and FormLoad event as well.
 
J

John A.

Have to be away from the computer for 5 or 6 days, I'll repost when I get
back.

Thanks for your response -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top