Form Loading Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am designing a database for Contract Management and in the last couple of
days when I load a form it can take up to 2 mins, I have been using the same
form for a while now. It is a Tab Control Form so it does have quite a few
controls on it but I have been using it for a while and have only recently
started experiencing problems with it.

When I load the form it displays..Calculation on the status bar.

I have checked the form load event, form current event but there are no code
in either, The RecordSource is set to a table.

Does anyone know of any other reasons why my form may be taken a long time
to load?

Thanks
 
hi Edgar,

Edgar said:
It is a Tab Control Form so it does have quite a few
controls on it but I have been using it for a while and have only recently
started experiencing problems with it.
Click to expand...
I suppose you have some subforms on your pages.
When I load the form it displays..Calculation on the status bar.
Click to expand...
If you have subforms on your tab control load them dynamically:

Private Sub PageControl_Change()

Select Case PCPageControl.Pages(PageControlTeil.Value).Name
Case Is = "YouNameIt"
SubForm.SourceObject = "YourSubForm"
End Select

End Sub

Try to avoid DLookups and his friends.

mfG
--> stefan <--
 
Back
Top