How can I Test for EOF in Form Navigation buttons?

  • Thread starter Thread starter Miguel
  • Start date Start date
M

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?
 
Miguel said:
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?
Click to expand...

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
 
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?
Click to expand...

Disallow the addition of records in the form.

What's wrong with the default Access navigation buttons?
 
Back
Top