Restricting which user can enter data

[Daniel P]

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

 

[Joan Wild]

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.

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

 

[Daniel P]

Thank you Joan, I will look into this further

Daniel