How to have new record appear every time I open form

[Guest]

How do i make a "new record" appear every time I open a form?

Thanks,

John

 

[fredg]

How do i make a "new record" appear every time I open a form?

Thanks,

John

In that form's Load event, write:

DoCmd.RunCommand acCmdRecordsGoToNew

 

[Guest]

thanks I got a message that i dont have the "docmd" in the macro section -
can I build that macro somehow?

Thanks,

John

 

[fredg]

thanks I got a message that i dont have the "docmd" in the macro section -
can I build that macro somehow?

Thanks,

John

Use code.
On the Form's Load event line write:
[Event Procedure]
Click on the little button with the 3 dots that appears on that line.
When the code window opens the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines write:

DoCmd.RunCommand acCmdRecordsGoToNew

Exit the code window and save the changes.
Open the form and it will open at a new record.

 

[Guest]

Awesome - thanks Much!!

thanks I got a message that i dont have the "docmd" in the macro section -
can I build that macro somehow?

Thanks,

John

Use code.
On the Form's Load event line write:
[Event Procedure]
Click on the little button with the 3 dots that appears on that line.
When the code window opens the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines write:

DoCmd.RunCommand acCmdRecordsGoToNew

Exit the code window and save the changes.
Open the form and it will open at a new record.