Continuous Subform Lock Field

[Lynn_AccessUser]

Can you lock a field on a continuous subform based on a value in another field. For example:

If Environ("home") <> "Username" And ApprovedCheckbox = 1 Then Amount.Locked = True

I have tried putting the code on the current, open, and load events.

There is one user who can approve the record and once he approves it no other user can change the amount field.

thanks!!

 

[Lynn_AccessUser]

Based on your response it sounds like the code should work on the current event. However, it doesn't.

Any suggestions.

Using Access 2000 with a SQL 2000 backend. Thanks

 

[Rich]

Post the code

 

[Lynn_AccessUser]

Sorry guess it wasn't clear in my first post that was the code I was using. Here it is again

If Environ("home") <> "Username" And ApprovedCheckbox = 1 Then Amount.Locked = True

Thanks for the help!!

 

[Lynn_AccessUser]

Got it. Even though ItemApproved is a bit field in the Access code ItemApproved = True not ItemApproved = 1.