Open new record on form load fails

[dab1477]

Thanks in advance for the assist. Pulling my hair out!
I am trying to run the following code during Form Load:

Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, SOC_Enter, acNewRec
End Sub

I entered the above code via the Properties/Event/On LOAD using Code Builder.

When I save and attempt to run I get a macros window asking me to enter a macro name and create the macro. I did this and no luck,


I am within an event procedure where I selected CODE BUILDER. I have saved file, exited, and returned. I get the following error:

"The expression ON_LOAD you entered as an event property setting produced the following error: Invalid outside procedure"

I have reviewed the HELP button without success. Where am I going wrong! How do I get this form to open to a new record?

Thanks.

 

[SydneyGeek]

If you always want to open a form to a new record, go to its Properties and change Data Entry to Yes.
If you want to open to a new record, and you are opening from a different location (eg a Command button on another form), use an event on the other form to run the DoCmd.OpenForm... line.

Denis

 

[dab1477]

BINGO! Winner, Winner, chicken dinner. You da man. Thanks Sydney. Data entry to YES worked.