Page Flickering/Loading strange

[adamtate94]

Hi

I have a form which contains two subforms, these forms are filtering from a big data source and when the form is loaded, the page flickers and the subforms flash visible and unvisible for a few seconds, after this the data loads fine.

Any suggestions to reduce this?

Thanks

 

[The_Doc_Man]

Look for having excessive numbers of .Refresh or .Requery in the VBA behind the form related to the two sub-forms.

Is this filter dynamically generated or statically generated?

 

[adamtate94]

Hi, thanks for the reply

The Server Filter is created with VBA after if statements, and example of one is below :

If Me.lblStatus.Caption = "Un-Assigned Items" Then
strServerFilter = "CompanyID = " & Me.CompanyID & " AND ULN IS NULL AND LocationID IS NULL"
btnAddItem.Visible = True


There is 4 of them

Cheers
Adam