Lock specific records

[D]

Hi:

Can you please tell me, if there is a way to lock just specific records in a
form?
So, for example records type A - actuals, I would like to not have them
changed=locked?
Just recrods type B budget, could be chaged, edited.

Thank you,

Dan

 

[Linq Adams via AccessMonster.com]

Private Sub Form_Current()
If Me.RecordType = "budget" Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End If
End Sub

Just replace RecordType with the actual name of your field that holds Actuals
or Budget.

 

[D]

Hi Linq:

Thanks!

My record is something like this: so I want to lock the 12 fields july to
june for rectype fy08A and fy09A and it will be more rectypes.

Do I change the code 12 times?

Dan


rectype july aug sep .... june
fy08A 3 4 5 6
fy09A 5 6 7 8
fy09B