Adding Record only

  • Thread starter Thread starter BobV
  • Start date Start date
B

BobV

I have an existing personnel db that I've recently had to add a considerable
number of new fields to. I now want to have all employees enter the
information for these new fields, but I can't have them viewing other
employees' information. To accomplish this I was going to make a copy of
the db, remove a lot of the other components I have in it, so that it just
reflects this employee info page/form, have them enter the info, and then do
an update query to the real db to update all the info. When they go in to
do this, I had wanted to have them open the form in Add mode only, viewing
only the single record they're adding, and not being able to view or edit
any of the other records in the db, but I can't seem to figure out how to do
that. It opens to a new record, and I've changed the properties of the form
to no for AllowEdits, AllowDeletions, AllowDatasheetView, etc., etc.; but
when it opens you can still scroll back through all the existing records and
look at them. How can I make it so you can only see the one new record
you're in when you open the db? I know I've done this before--but it's
apparently been a while.

Thanks for any help (also for any suggestions on a better way to accomplish
the overall goal, if there is one).
Bob
 
Back
Top