Form with subforms very slow to load

[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.

 

[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.

 

[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 -