Calling a Sub from another Form - Xtreme Visual Basic Talk

08-05-2004, 09:00 AM

theberzerker69 theberzerker69 is offline

Centurion

Join Date: Dec 2003

Posts: 148

Calling a Sub from another Form

I have a project with multiple forms. Most of them are displayed from the main form, Form1.

Form2
l
Form5--Form1--Form3
l
Form4

Form1 displays data from an access table. The other forms are used to add/edit data in the datatable. When the other forms are unloaded or closed, I need the datatable on form1 to be refreshed. This is done on Form1 with a sub "QuerySub()." Right now the QuerySub is put in a random control behind a picture box with the code:

Code:

Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
QuerySub()
    End Sub

So right now the Button is clicked from the other forms like so:

Code:

Form1.Button1.PerformClick()

This works, but it isn't clean. Is there a way to execute a Sub on Form1 from Forms 2-5?

Thanks in Advance

Tom

Last edited by theberzerker69; 08-05-2004 at 09:09 AM.

08-05-2004, 10:36 AM

PWNettle

Verbose Coder

Retired Moderator
* Guru *

Join Date: Dec 1999

Location: Phoenix, Arizona

Posts: 3,011

The more "oop correct" way to do it would be to make your QuerySub() public, pass a reference to form1 to your other forms whenever you instantiate them, and then call QuerySub() from from the other forms via the reference back to form1.

Code:

'  In some other (sub) form:
frmFormOneReference.QuerySub()

Another approach would be to have a seperate object that models/represents your data and includes the update functionality and pass around references to the data object instead of having the data functionality tied into your form (which is a display/control element, not a data element, per se).

Paul