how to trigger a button event at same form

[newaccess]

I use MS access 2007 at window xp.
I would like to be able to trigger the "on click event" of a ADD button WHEN FORM OPEN ( ON FORM OPEN ENEVT)
I also able to trigger the "on click event" of a ADD button when I clicked Save button at same form.

Thanks for help!

new access

[mcktigger]

Can you explain a bit more what you mean?

Do you want the button to be clicked by the user or do you want the button to do something automatically when the form opens. If you want the button to do something automatically then why not just code the On Load event of the form to do xyz rather than trigger the on click event.

Same for the Save button why not just program the on click event of the save button to do what you want the add button to do.

I'm not quite understanding what you're trying to do so maybe you can explain a bit more.

[June7]

You can call any event subprocedure just as you would any sub or function. Example: Call btnExecute_Click

[newaccess]

I copy your command to form open event as
Private Sub Form_Open(Cancel As Integer)
Call ADD_Click
End Sub
But I get message as
compile error: sub or function not defined

Any suggestion?
I use MS access 2007in window 7

[ssanfu]

I think the OPEN event is too soon. Try the LOAD event

From Help:

When you first open a form, the following events occur in this order:

Open > Load > Resize > Activate > Current


The Open event occurs when a form is opened, but before the first record is displayed

The Load event occurs when a form is opened and its records are displayed.

[June7]

No idea why that error except maybe can't use in Open event. My example is code in a combobox AfterUpdate event.

You want form to open to new record but still have existing records viewable?

[newaccess]

Hi Movice,

Could you put some example of trigger a add button event at access form open?
I am still fight this issue.

I am using access 2005 in window XP

Thanks

Jimmy

[June7]

What do you really want to do? Do you want form to move to new record immediately after opening?

[Missinglinq]

I, too, would have guessed that Form_Open was too early for this to work, but testing, using the Form_Open event to call the OnClick event of Command Button whose code is

DoCmd.GoToRecord , , acNewRec

works quite well. Are you absolutely positive the button was named ADD? Is this code in the Code Module behind the Form the button resides on? I assume that the button, when clicked, works; is this true?

Linq ;0)>

[newaccess]

Dear Missingling,

Thanks for your help!! It works.

newaccess

[Missinglinq]

Glad we could help!

Linq ;0)>