permission to change a text box

[54.69.6d.20]

I have a Employee table in which I use to setup permissions to be able to access curtain things, however, I'm stuck on how to give permissions to change a value in a text box.

I have a search Manufacture Form and when you search it, will show the results in another form. I want to give access to curtain people to make changes to the price field without going into the table manually.

In the Employee table I have a field called EQUIPlookUpChange (0=no access and 1= access)

Private Sub TextField1_Change()
If EQUIPlookUpChange Then
  ????????TextField1_Change
  Else
  MsgBox "You don't have access to make changes.", vbOKOnly, "Admin"
 End If
End Sub

Thanks for the help. Not having the greatest of days

[rpeare]

so you have a login to your database and are able to differentiate users just fine?

If so all you have to do is lookup that user's permission and either lock or unlock the field in question at the time the form is opened. You don't want to have to check the permission every time it's accessed assuming you don't have multiple people using the same database at the same location at the same time.