Open in a New Record

[Abbosy]

Hi there Forum

How to get about to make a form opens a new record when loaded.
Really appreciate your help guys.


Thanks a lot

 

[pr2-eugin]

Is this from a click of a button? If so you can make use the DataMode parameter of the DoCmd.OpenForm method.

 

[NitroN1ck]

What you could do is:

Create -> Form Wizard -> Then proceed through the wizard adding the fields from a particular table...

 

[Abbosy]

Hi again Paul and NitroN1ck

I am using MS Access 2013. I was trying to actually find the method you mentioned but embarrassingly couldn't find it. Instead I went to the Event and chose "On Click" and clicked on the event builder. It openned in this new and amazing "Macro Tools".
It showed "OpenForm" and had these six fields "Form Name", "View", "Filter Name", "Where Condition =", "Data Mode", "Window Mode" plus a combo box dabbed "Add New Action".
These fields have explainatory tips when rest the mouse' arrow on them; so I changed the "Data Mode" to "Add" and that actually openned the form in a new record. I'm going to use this one, but really thank you for helping me out on this one.

I've attached 2 pics on how this looks

Many Thanks to you all

 

[pr2-eugin]

Glad you have it sorted. Good Luck !