i have a subform, textbox1 is number format and textbox2 is text format..and
both are not a primarykey. subform data is from query (though this will help).


is there away to avoid duplication number in textbox1. when there is a
duplication, it show message box with the detail of textbox2.

Your help is greatly appreciated to solve this matter.


Thank you in advane

--
Message posted via http://www.accessmonster.com