M
missamay
I have a set up Access security on a database containing two forms. One
that users can only create new records and one where they can edit
records. When a new record is created, I want the user's login (Access
login or Windows login) to be automatically entered in the form/table.
And when they open the Edit form I want them to only be able to view
and edit the records they created.
I have read an earlier post on this subject from 2004 and I tried the
code, but received errors that I could not resolve.
I also tried using the CurrentUser() function on the form, but could
not get the current user displayed from this function on the form to
transfer to the actaul data table.
Does anyone have any suggestions or code I could try? Thanks.
that users can only create new records and one where they can edit
records. When a new record is created, I want the user's login (Access
login or Windows login) to be automatically entered in the form/table.
And when they open the Edit form I want them to only be able to view
and edit the records they created.
I have read an earlier post on this subject from 2004 and I tried the
code, but received errors that I could not resolve.
I also tried using the CurrentUser() function on the form, but could
not get the current user displayed from this function on the form to
transfer to the actaul data table.
Does anyone have any suggestions or code I could try? Thanks.