hi,
i have a system, that has a voucher number, payee, date, check number and amount. my system is i'll run the form then i'll input it to the textbox (voucher number, etc) after that i'll click cmd btton then the values will be entered to the sheet1, like this:
vouchernumber 111111 payee 111111 date 111111 checknumber 11111 amount
2012-0001 1111111111 paulo 1111111 12-4-90 111 123 111111111111 10.00
2012-0002 1111111111 pau 11111111 12-4-91 111 1234 111111111111 5.00
While in the form, i want to check the number in (vouchernumber and checknumber) if its used already, and when its used already the msgbox will pop-out. Number already in used.
Thank you!
Bookmarks