Non editable fields

[Guest]

Hi All,

I have set up a database where the user enters information by using a form.
There is a field in my tables and form that is called status which records
the different statuses that the an application is at. This is a drop down
list. Once the application is "finalised" the users selects the finalised
status. I would like to be able to make the record locked when this
selection of finalised is made. Can someone please advise me on how I may be
able to do this? I don't want any of the fields locked when other statuses
are shown.

Thanks in advance.

 

[Al Campagna]

Janine,
Assuming your "finalized" is a check box (T/F)...
Use the OnCurrent event of the form...

If Me.Finalized = True Then
Me.Allow Edits = No
Me.AllowDeletions = No
Else
Me.Allow Edits = Yes
Me.AllowDeletions = Yes
End If