Disable selection of new record

J

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
 
J

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
 
J

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.
 
D

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.
 
J

Jack Sheet

Thanks - that worked fine

Douglas J Steele said:
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.
Click to expand...
 
Top