Subform blank record

[Chris]

My subform works just fine, except... there is always a blank record
displayed. (Either first or last depending on my sort.)

The blank record does not exist in the underlying table or the query I use
as record source.

Is there a way to remove this erroneous displayed record? My suform is
continous and I fear its something I must live with.

 

[Jeanette Cunningham]

Chris,
is your subform set up to view existing records and also add a new record?
If this is the case, the blank record is the empty row waiting for the new
record.
If you set Allow Additions to No, (Data Entry tab), you can still edit the
data, but the row for the new record won't show automatically unless you
click the add new record button.

Jeanette Cunningham

 

[Linq Adams via AccessMonster.com]

"If you set Allow Additions to No, (Data Entry tab), you can still edit the
data, but the row for the new record won't show automatically unless you
click the add new record button."

Actually, if you set the AllowAdditions to No, you won't be able click the
"add new record button" because it'll be grayed out!

If the subform is in Datasheet View, as most are, you won't be able to work
around this. If the subform's in Continuous View, you can add a custom
command button to allow adding a new record.

Linq

 

[Chris]

Thanks to you and to Linq. You gave me clues.

The solution was to set the continuous form to Snapshot and turn off Allow
Data Entry, et al.


--
Thanks for your help,
Chris

Chris,
is your subform set up to view existing records and also add a new record?
If this is the case, the blank record is the empty row waiting for the new
record.
If you set Allow Additions to No, (Data Entry tab), you can still edit the
data, but the row for the new record won't show automatically unless you
click the add new record button.

Jeanette Cunningham