Allow Edit conditionally 1

[Jitterbug]

I have a form with numerous records in detailing houses.

I want to set the forms properties so that if the houses status is sale completed, that record cant be edited.

I know you need to use an if statement but it refuses to work.

Jitterbug

P.S. And the procedure has to be put in the on current command, right?

 

[ToeShot]

one way is to set the sales as a yes/no field and use the if statement in the OnCurrent event.
Example:

If(Me.SalesCompleted) Then
Me.AllowEdits = False
End If

HTH