Disable selection of new record

[Jack Sheet]

Access 97.

How do I in a form disable the possibility of selecting a new record?
ie so that on the navigation bar the ">*" icon is greyed out or invisible.

Thanks

 

[Rick B]

Set the form's "allow additions" property to false.

 

[Jack Sheet]

That's great Rick, I should have been able to find that, sorry for troubling
you.

Next one is hopefully not so obvious:
How do I set a form so that it will ONLY allow new entries, ie deny access
to any previously saved entries to a table? If that is too difficult,
perhaps get it so that when opening the form it focuses immediately on a new
record?

Thanks

 

[Jack Sheet]

Belay that. I sort of have a solution: set properties to allow additions
but disallow edits.
It looks a bit naff, because it allows you to select existing records (and
indeed focuses on first record rather than new record) with every appearance
of permitting edits until an edit is attempted. It will do for now, but
needs a tidy up I think.

 

[Douglas J Steele]

If you set the form's DataEntry property to Yes (True), it won't show any
existing records, but will let you enter new records.

 

[Jack Sheet]

Thanks - that worked fine

If you set the form's DataEntry property to Yes (True), it won't show any
existing records, but will let you enter new records.