extra blank record

  • Thread starter Thread starter hje
  • Start date Start date
H

hje

I have a query that displays its results into a form.
When I move through the displayed records , it always
tacks on a blank page at the end. (ex: 2 records result
from the query. When I go past record 2, another blank
record displays).

This makes sense, since the last record in my table is
blank (the key is an autonumbered record value) and it is
appearing at the end.

How do I stop this record from being displayed when a user
moves through the results?
 
hje said:
I have a query that displays its results into a form.
When I move through the displayed records , it always
tacks on a blank page at the end. (ex: 2 records result
from the query. When I go past record 2, another blank
record displays).

This makes sense, since the last record in my table is
blank (the key is an autonumbered record value) and it is
appearing at the end.

How do I stop this record from being displayed when a user
moves through the results?
Click to expand...

That "blank record" is the placeholder for an editable Datasheet or form where you
can type in a new record should you want to add one. To remove it you either need a
RecordSet that doesn't allow edits or you can set the form's AllowAdditions property
to No.
 
Back
Top