Dear All,

How to avoid record to be save after message pop up.

after.input:
if orno = prev.orno then
message (" Order number exist")
input.again()
endif

My problem is cursor will be in same field and asking for new input(as per expected) but if user click icon save, record save(I dont want to allow user to save).

You may use skip.io() function within before.wrtie subsection of main.table.io

Or you can try it in check.input rather than after.input. Or you can try it in choice.update.db - in the before.choice section. Several places I think this type of check can be implemented.

Hi Guru Mark,
Problem resolved with your solution. Thank you.