Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
lock row in continuous form? 1
- Thread starter Pampers
- Start date
![[afro]](/data/assets/smilies/afro.gif "[afro] [afro]")
-
1
- #2
Probably need to give some specifics on this. You can use the on current event. Example
Private Sub Form_Current()
If Me.strFld1 = "Test" Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If
End Sub
In this example once I enter the value "Test" in a field it is pretty much locked.
Private Sub Form_Current()
If Me.strFld1 = "Test" Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If
End Sub
In this example once I enter the value "Test" in a field it is pretty much locked.
- Thread starter
- #3
- Status
