Max Records issue

[Alice]

Hi,

I have a form for which I have set Max Records = 1 so
that forms loads up quickly. I am now running into the
following issue:

When user clicks on button "Add new record", I have code

DoCmd.GoToRecord , , acNewRec

My issue is that now the whole whole form becomes
uneditable and I am not able to add a new record.

I am very new to this. Please please help me.. I would
really appreciate it.

Thanks

 

[Alex MRu]

Set Max Records=0 before the instruction DoCmd.GoToRecord , , acNewRec

 

[Alice]

Thanks Alex.

But my issue got resolved by setting the "Unique Table"
property. Once I set my "Unique Table" to the table I
want to update, the command works like a charm

Thanks