How to Load a subForm by clicking a button on the Main Form

Im having 2 forms Main Form and the Sub Form.

The Sub Form on load retrieves data from the database and displays them in the text box.

I added the sub Form to the Main Form.

I have created a button in the Main Form on clicking it shud open the loaded Sub Form.

I created a instance of sub Form and used SUBFORM.SHOWDIALOG() But this just opens the sub form instead of loading the data from the database.

Is there anyway how I can load the Sub Form instead of just showing it by clicking a button on the Main Form.

I appreciate ur help in advance

I dont see any problem with the way you have chosen, maybe there is another problem in your code that prevents the data being read from the database. In fact ShowDialog goes through initiating,loading and showing the form.

Yeah there was some other problem. I fixed da problem now.

THanx a lot for ur reply