Set allow edit property conditionally

[Jitterbug]

I have a form with house details on it.

I want to set the allow edit property to false only if the status combo box contains sale completed. I still want to be able to edit other records.

I know i have to use an if statement in VB, but i cant get the code to work, even though i dont get any error messages. Also im not sure which event to post the code under.

Jitterbug

 

[Databaseguy]

Private Sub cboYourCombo after_update()
If me.cboYourCOmbo = "Your Value" then
me.allowedits = True
Else
me.allowedits = False
End If
End Sub Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy