New record

[Super Suarez]

Hi All,

How do I make the windows default navigation work to the following:-

Next record that navigates to next, but does not create a new record when at EOF

New record that creates a new record.

I've tried turning off 'Allow additions' for the form, but that turns off the 'New Record' button, so that's not right

Perhaps it's me but the default way in which the navigation buttons work is strange. I would have thought the next button would only go next and wouldn't do new. That's what I'm after.

Hope you can help

 

[pr2-eugin]

You need the Allow Additions to be Yes, so new data can be entered. Have you placed any manual code that will detect EOF and do otherwise.

When you say it does not create new record, do you mean even if you enter information, it is not updated in the table?