I noticed one of my forms was loading very slowly. I have now figured out that
if I remove one of the subforms on this form, this problem disappears.

I have tried basing subform on a query and have indexed link field in the
subform - this does not help. Incidentally subform is not large.

Any suggestions to make this run better?

Thanks for the help in advance.

mfs43@aol.com (MFS 43) wrote in message news:<20040509223624.08010.00000154@mb-m04.aol.com>...[color=blue]
> I noticed one of my forms was loading very slowly. I have now figured out that
> if I remove one of the subforms on this form, this problem disappears.
>
> I have tried basing subform on a query and have indexed link field in the
> subform - this does not help. Incidentally subform is not large.
>
> Any suggestions to make this run better?
>
> Thanks for the help in advance.[/color]

Without code or SQL it's hard to be emphatic. However, I have had
similar problems which occurred because I had code which repeatedly
fired the Form_Current event. Try putting a breakpoint in the
Form_Open event (the first event that fires) and see what is
happening. If there is nothing untoward, you may need to look at the
query.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk