How can I Test for EOF in Form Navigation buttons?

[Miguel]

I used the form wizard to add a "Next" record navigation button on a Form. It
works ok, except that at the end of the recordset it adds a new record. How
can I prevent this?

 

[Larry Linson]

I used the form wizard to add a "Next" record
navigation button on a Form. It works ok, except
that at the end of the recordset it adds a new
record. How can I prevent this?

First step would be to check that you don't have default values specified
for some fields in the table itself, or in a control on the form. That
could cause what you are experiencing. If you do not have a default, but
have a required field (and there should be some field in almost every record
definition which "needs to be present"), which, if not set will cause an
error when "whatever" tries to write the record.

Larry Linson
Microsoft Office Access MVP

 

[David W. Fenton]

I used the form wizard to add a "Next" record navigation button on
a Form. It works ok, except that at the end of the recordset it
adds a new record. How can I prevent this?

Disallow the addition of records in the form.

What's wrong with the default Access navigation buttons?