Form overwriting record in table instead of adding record 2

[netrusher]

I have a form associated to its own table. One of the
fields on this form EcnNumber is populated using
and OpenArgs statement. The other fields on this form
are yes/no boxes. My issue is as follows.

When I check my yes/no boxes and then close the form
the table is updated correctly. The next time I open
the form and check my yes/no boxes etc and close the
form the first entry in the table is overwritten. I would
like to have a separate record each time I utilize the
forma and not have it overwrite the existing record.
What am I doing wrong?

 

[JoeAtWork]

When you open the form, what value are you giving for the AcFormOpenDataMode argument? It should be:

docmd.OpenForm "MyForm",,,,acFormAdd

 

[netrusher]

This is what I have right now for the code when the form
is opened.

DoCmd.OpenForm "PopupChecklist-01EcnAnalystReleaseDate", acNormal, , , , acFormAdd, Forms!ECNBCNVIPfrm![ECNBCNVIP ID]

 

[Golom]

Where you have ", , , ," ... there should be only three commas.

 

[JoeAtWork]

It should be:

DoCmd.OpenForm "PopupChecklist-01EcnAnalystReleaseDate",acNormal, , ,acFormAdd, ,Forms!ECNBCNVIPfrm![ECNBCNVIP ID]

 

[netrusher]

Golom,

This is the code that works. Thanks for your help.

DoCmd.OpenForm "PopupChecklist-01EcnAnalystReleaseDate", acNormal, , , acFormAdd, , Forms!ECNBCNVIPfrm![ECNBCNVIP ID]

 

[PHV]

Tip: put the cursor inside the OpenForm word in your code and then press the F1 key.