Passing Parameter with Windows Logon

[cbsquared2000]

I need help with a form. I want to create a form that has 10 controls. 5 controls I want one department to see (or change and update), the other 5 I want a different department to see. Is there a way to do a if...then... statement to allow the controls to be updated based on Windows Logon? I can set the security per table, but not sure how to set it per control on form.

Thanks.

 

[Rolliee]

Simply set the one's you want one group to see to a visible and the others to non-visible.

I need more inifo to be more specific. Perhaps some of your code.

Rollie E

 

[cbsquared2000]

Everyone uses a windows logon in our company. Once they long on, I would like to set security on the controls rather then the whole form. Below is example:]

Private Sub protect_control()
If windowslogon = "cbrown" then
fix_date.locked = true
End If

The thing I am not sure of is how the statement knows what the windows logon is. Is there a way to do that?

Thanks