How to have new record appear every time I open form

J

jmuirman

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

Thanks,

John
 
F

fredg

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

Thanks,

John
Click to expand...

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.
 
J

jmuirman

Awesome - thanks Much!!

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

Thanks,

John
Click to expand...

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.
Click to expand...
 
Top