D
deb
I have a table called tblVersion with a field called User_ReadOnly. If
User_ReadOnly is "UserReadOnly" the I do not want the user to be able to
add, edit or delete any data.
If DLookup("[User_ReadOnly]", "[tblVersion]", "[UserID] = '" &
Environ("username") & "'") = "UserReadOnly" Then
Make all forms (main form and subform 1 and 2) read only.
fProject, fDeliv, fTrans are my forms.
What is the best approach to this?
I am not sure where to begin.
Thanks
User_ReadOnly is "UserReadOnly" the I do not want the user to be able to
add, edit or delete any data.
If DLookup("[User_ReadOnly]", "[tblVersion]", "[UserID] = '" &
Environ("username") & "'") = "UserReadOnly" Then
Make all forms (main form and subform 1 and 2) read only.
fProject, fDeliv, fTrans are my forms.
What is the best approach to this?
I am not sure where to begin.
Thanks