Make completed records read only?

[WinDancer]

Is there a way to make some records in a table read only?

Thanks,
Dave
[12 days until retirement!]

 

[John Big Booty]

You could set the Form's AllowEdits property to False, you just need to determine how you are going to identify records you wish to protect and then do a logical test in the form's On Current event and use something like;

    If [I][COLOR="Red"]Test for protect indicator[/COLOR][/I] Then
        Me.AllowEdits = False
    Else
        Me.AllowEdits = True
    End If

 

[WinDancer]

That works just fine- thanks!
Dave