Message before entering from value list

[Jaume]

I am modifying a fm database with a new value-list entering data. I want to apply this facility to the NEW records, but , if the field is not empty (old records), i would like to show a message asking, for example "

[Fitch]

Take the field out of the tab order and specify it as a button, with the script:

If [ not IsEmpty(yourField) ]

. Show Message("do you really...?")

. If (Status (CurrentMessageChoice) = 2 )

. . Exit Script

. End If

End If

Go to Field(yourField)

So when you click the field, if the field is not empty, you'll get a message. I've made the default choice (1) OK, and the other (2) Cancel. So if you click Cancel, the script Exits. Whereas if you click OK, or the field is empty, the script performs the last step and goes into the field.

[Jaume]

Thank you, Tom, for your quick and useful solution. It really works!

Jaume