Setting form to open New Record from command button and not form's OnLoad

[Pawtang]

My main data entry form can be opened from various other locations representing different contexts: for example, I have a list that shows all "open" records in a continuous form with a button on each line to open the detail view (main form) for that record. Because I have that command button open the form to the specific record, I can't have an OnLoad property for the form that sets it to New Record, or it would kill that function and always open to new. What I'd like to do is have my primary entry point to this form - a button in the main menu - load the form to a New Record.



I have started with a VBA sub rather than Macros because I think that will be an easier method to accomplish this, but I'm not sure what property to set to achieve this.

Private Sub openFrmRMA_Click()    
DoCmd.OpenForm "frmRMA"
End Sub

[davegri]

Use the OpenArgs argument in the docmd.openform statement. The openargs value can be evaluated by the form's on_open event to know what it's expected to do.

[Pawtang]

Use the OpenArgs argument in the docmd.openform statement. The openargs value can be evaluated by the form's on_open event to know what it's expected to do.

Worked like a charm and glad to know about that property too! Seems universally useful

[davegri]

Worked like a charm and glad to know about that property too! Seems universally useful

Glad it was a solution for you. Good luck with the project!