Limit form to existing records

[GuillaumeJ]

Hi everyone

Here is my problem

I have a table containing records. I created a form that displays the records' details. To navigate through the records, I added two buttons "previous record" and "next record" (using GoToRecord method)

When the last existing record in the table is displayed, and the user pushes the button "next record" once again, the form gets blank and adds automatically a new record to the table.

How can I limit the navigation on the form to only existing records, without giving the possibility to create a new record in the table ?

Any help would be great !

Thanks a lot

Guillaume

 

[jsi]

Hi
set the form property 'AllowAdditions' to No
That will do the trick

HTH
Jim

 

[GuillaumeJ]

Thanks !

Guillaume

 

[jsi]

Glad to help
Jim