It takes time when loading a form

[ballwah]

Hi,

I got a problem when loading another form ... from my 1st form. I'll need the 2nd form to control the 1st one (by calling one function of the 1st form), therefore, I've the below coding when opening the 2nd form:
Dim A As New form2(Me)
However, everytime I open the 2nd form, it takes time...can anyone tell me how to prevent loading so slowly?

Many thanks!!

 

[lingsn]

The form will appear slower if you have some code in the form load event to load large amount of data from database.

Normally an empty form won't take long time to show up.

 

[Inhua]

Yeah, you should check two things:

1. The code under Form_Load
Try to clear the code under Form_Load event handler
2. The controls on the form
Try to decrease the controls on the form

Hope this helps!

 

[ballwah]

Yeah....thanks guys!!
I got the reason below:
under Form Load, I tried to fill in all related dataset...while the database is getting larger...therefore it'll take longer loading time...So, what do you think I can solve this problem?

 

[Inhua]

You can choose to create a button on the form to load the data. I recommend you combinate this button to login and load the data. When the login and password is valid, you call the procedure to load the data using this visual hints:

1. Change the mouse pointer to hourglass.
2. Add a progress bar to let your user know that the big data is being loaded

Cheers!
Inhua