I have a main menu form with buttons that open other forms. In the second form in the On Current procedure I have some code to check a value in a table to determine if the allowediting should be true or false. But for some reason the code is being executed and allowediting is begin turned to false, but when the form displays the allowediting is no longer turned off. I have looked and tried to watch where it is being reset, but without luck. Can anyone give me a clue as to what might be turning the allowedits back on. Thanks in advance for the help with this. Here is my statement that I'm using.
If Nz(Not Me.approval_close_5003) Then
Me.AllowEdits = False
Me.Text52 = "Project has been closed, no further pdating"
Else
Me.AllowEdits = True
Me.Text52 = " "
End If Thanks Travis.
If Nz(Not Me.approval_close_5003) Then
Me.AllowEdits = False
Me.Text52 = "Project has been closed, no further pdating"
Else
Me.AllowEdits = True
Me.Text52 = " "
End If Thanks Travis.