In
DDrowe said:
I have a database with a form on which data is entered. It will be
available on any computer with MS Access. My issue though is went it
is opened, I want it to go to a blank form and not allow the person
to be able to scroll back through the rest of them OR I want them to
be able to edit only the open one and not ones entered earlier. Can
this be done with out the security feature?
You can set the form to Data Entry mode, which opens to a blank form and
only lets them review records that they've entered in this session --
that is, from the time the form is opened to the time it's closed.
Would that be sufficient to your needs?
Data Entry mode would let them review and edit the records they've
already entered *in the current session*. If you need to, you can
prevent that by setting the form's Allow Edits and Allow Deletions
properties to No. However, that does make it harder for users to
correct data entry mistakes, so you'd better have good pre-save
validation code in effect.
If you *really* need to keep the form from ever displaying any other
records than the one currently being entered, excluding even those
entered in the same session, you can set Data Entry to Yes and put code
in the form's AfterUpdate event to requery the form. That will clear
the form completely of all but a new blank record, whenever a record is
saved. But that's a pretty extreme thing to do.
Be aware that while restricting user's editing capabilities via the form
is quite easy, preventing them from reading data that is already stored
in the table by any other means -- opening the table or a query of it
directly as a datasheet, for example, or by linking to the table from
another application -- takes a lot more doing. You can make it very
hard, though not impossible, with user-level security. Does user-level
security work in Access 2007? I can't remember, but there's a flag in
my memory about it.
