OnEnter Event

[The Professor]

Hi,

I have a SubForm as a Control on a MainForm.
I have code in the SubForm's OnEnter event, which I need to run when a New Record is created - either in the MainForm, or in the SubForm.



What other events would trigger the OnEnter event? Is it triggered only when a New Record is generated - or is it triggered every time the SubForm control is activated?

Prof?

[CJ_London]

Events do not trigger events - actions do, although some actions can trigger more than one event

See this link for more information on what events occur in what order

https://support.office.com/en-ca/art...7-ce86553682f9

[ranman256]

dont use ON ENTER
use BEFORE UPDATE
this can examine the data bfore you save.

[June7]

OnEnter is triggered when moving to the subform control. https://msdn.microsoft.com/en-us/lib...or=-2147217396

Exactly what do you want to happen? What is the code?

[CJ_London]

dont use ON ENTER

subform controls only have enter and exit events

[The Professor]

Exactly what do you want to happen? What is the code?

Hi, Thanks everyone.

What I want is, each time a New Record is created I want to run a small piece of code that will update a field on the SubForm. I don't want the code to run unless it is a New Record.

It had been suggested to me that I place the code in OnEnter event of the SubForm, but I'm not too sure this is the right place for it. I know I can probably use, If Me.NewRecord Then, to test for a New Record, then execute the code, but which SubForm event is the best to place for this code? I'm now thinking not OnEnter?

Prof

[Missinglinq]

If you want the code to run when a New Record is entered into the Main Form, the code will have to placed in the Main Form. When moving from a Main Form to a Subform, the Main Form Record is saved and hence is no longer a New Record.

But in order to really advise you, you need to answer the questions

Exactly what do you want to happen? What is the code?

Linq ;0)>

[June7]

Try the main form AfterUpdate event.

If Me.NewRecord Then
'do something with the subform
End If