Confirming field change on a form

shogan@mila.ie

Hi all...

How could you ask the user to confirm a field change on a form?

E.g.

In the Item card, how could you confirm a change {Yes/No} in the Vendor Product No. or Shelf/Bin No. fields?

I am thinking this would need to be done by a trigger? Is this easy to do?


Thanks a million :shock:

Stephen H.

Sbhat

Hi Stephen,

I would have given you more specfic answer if your question was clear. From what i understand you could use the following statement on the OnValidate trigger of the Shelf Bin No.
If "Shelf Bin No." <> xrec."Shelf bin no." then
if not confirm('Do you want to change the value',false) then
exit;

This should work else On OnModify trigger check for the "shelf bin no." and the other field.

Thanks
Best regards
Suresh.
NJ.

eromein

I would like to add that the statement Sbhat posted should be at the beginning of the Validation trigger. This because he is using and EXIT to "break" the routine if you confirm the question with "not yes".

(And use text constants instead of typing the message in the confirm)