Load a form and call a function right after

[fr2]

I have FormB say with companies info (Add, Edit, Update buttons ..ect). When I load the form, I want to activate the click event for CmdAddNew button

So say I am in FormA ... and I launch

Load FormB

how do I have FormB then automatically call
...CmdAddNew_Click()

Should I have a Public module level variable set in FormB .... so that I can set it in FormA first, ....

then in the form load for FormB test for it ... and launch CmdAddNew_Click() if needed?

 

[Andrzejek]

You can:

[blue]Private Sub[/blue] Form_Load()
   [blue]Call[/blue] AddNewRecord
[blue]End Sub[/blue]

[blue]Private Sub[/blue] CmdAddNew_Click()
   [blue]Call[/blue] AddNewRecord
[blue]End Sub[/blue]

[blue]Private Sub[/blue] AddNewRecord()
   [green]'Your code to add a new record here[/green]
[blue]End Sub[/blue]

Or you can:

[blue]Private Sub[/blue] Form_Load()
   CmdAddNew.Value = [blue]True[/blue]
[blue]End Sub[/blue]

Have fun.

---- Andy

 

[Golom]

Hmmmm ...

My command buttons don't have a "value" attribute so I'm not sure how that would work.

In any event, I wouldn't do this in Form_Load because the form is not completely initialized or displayed until Form_Load completes. Try Something like

Dim StartWithNewAddNew As Boolean

Private Sub Form_Load()
    StartWithNewAddNew = True
End Sub

Private Sub Form_Activate()
    If StartWithNewAddNew Then
        StartWithNewAddNew = False
        CmdAddNew_Click()
    End If
End Sub

in FormB.

 

[Andrzejek]

Hmmmmm....

My VB 6.0 command buttons have .Value:

Have fun.

---- Andy

 

[dglienna]

probably vba

-David
2006, 2007 & 2008 Microsoft Most Valuable Professional (VB)
2006 Dell Certified System Professional (CSP)

 

[dilettante]

Setting Value = True "clicks" the button.

 

[dilettante]

It is often useful to have a Timer on the Form with a short Interval that is used as a "one shot" timer. In the Timer event you disable the Timer control and then peform your "one time startup" action.