Restricting which user can enter data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I created a database with user groups ... and all the othere bells and whistles

However, my question is: " Is is possible the restrict which users can enter information into specific field on a form?

Let say Daniel would be able to enter a date in the date field but no one else could

Thanks for all your help

Daniel
 
Daniel said:
I created a database with user groups ... and all the othere bells
and whistles.

However, my question is: " Is is possible the restrict which users
can enter information into specific field on a form?"

Let say Daniel would be able to enter a date in the date field but no
one else could.
Click to expand...

Since you've implement user-level security, you can use the function in the
security FAQ to see if the current user is a member of a certain group.

The faq is available from
http://support.microsoft.com/?id=207793

The function is called faq_IsUserInGroup

In the open event for your form, you can use the function
If faq_IsUserInGroup ("groupName", CurrentUser()) = true then
me.DateField.locked = false
else
me.DateField.Locked = True
End if
 
Back
Top