hide blank record on a form

[hullstorage]

on my main form
there seems to be a blank records showing all the time
in brackets it has (new)
is there a way of hiding this
thanks

there is a picture to give you some idea what i mean


simon

 

[RuralGuy]

On the Data tab of the properties sheet for the form, set AllowAdditions to NO.

 

[Pat Hartman]

The record is there as a place to use to add a new record. If you do not wish to add records with this form, change the AllowAdditions property as has already been suggested. If you wish to add records via this form, leave it. If you are comfortable with VBA, you can set the allowAdditions property to No and create form fields on the parent form that you can use to add new rows. you should find samples here.