Max Records issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alice - 27 Sep 2004 20:39 GMT

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

Reply to this Message

Alex MRu - 27 Sep 2004 21:23 GMT

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

> Hi,
>
[quoted text clipped - 13 lines]
>
> Thanks

Reply to this Message

Alice - 28 Sep 2004 14:20 GMT

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

>-----Original Message-----
>Set Max Records=0 before the instruction DoCmd.GoToRecord , , acNewRec
[quoted text clipped - 18 lines]
>
>.

Reply to this Message