Fellow FMers,

I want to write a script, which would be activated when I tab into the field. For example, if I type a duplicate value, and then attempt to continue the record, the warning message will show.

I can do this with a transparent button, but this takes care of “clicking” into the field, but does nothing for “tabbing”.

I tried "If(Status(CurrentFieldName)= "Fieldname", but that didn't work.

Any suggestions or recommendations are greatly appreciated.

Thanks in advance.

Well, one could do it with plain FMP by keeping the user in a script the entire time that they are on the layout and checking every second for the current field, but it's probably a whole lot easier to go the plug-in route.

Chuck

Hi,

You can't do that with plain FM, you need a plug-in to do this job.

Check on http://www.wmotion.com/oazium/events/ for a solution (sorry, not free software)

Erwin

If what you want to do is show a message if a field value exist why not use validation instead of a scripted message. You can set the field to be unique and show message if not with choices to continue or not.

quote:

---

Originally posted by bobsmith:

If what you want to do is show a message if a field value exist why not use validation instead of a scripted message. You can set the field to be unique and show message if not with choices to continue or not.

---

Bobsmith,

That would be way easier, but the problem is that it is a calculated field, and I don't know how to set it to be unique, or to index it. I want to show a message if the value that was entered is a duplicate.

Example: My calc field is a combination of FieldA and FieldB. So when the user tabs out of FieldB, I want to show the message. Is that possible to do with a calculation? If yes, could you please specify details?

Thank you