lookforsmt
Registered User.
- Local time
- Today, 14:04
- Joined
- Dec 26, 2011
- Messages
- 672
Hi! all
Tried to search the net, but unable to find this.
Below 3 fields which I am trying to capture. On the before update event it should match all the below 3 details for the given Entry_Date(if one of them is not matching it should not capture and a pop-up alert msg of the mis-match
The current before update event does not give me the result, can you suggest me what i am doing wrong pls.
Ref_Nos
Branch_Name
Account_Nos
The data to be captured in form, "frm_CheckerVerify" is mentioned below.
i am attaching the DB for clarity.
Tried to search the net, but unable to find this.
Below 3 fields which I am trying to capture. On the before update event it should match all the below 3 details for the given Entry_Date(if one of them is not matching it should not capture and a pop-up alert msg of the mis-match
The current before update event does not give me the result, can you suggest me what i am doing wrong pls.
Ref_Nos
Branch_Name
Account_Nos
The data to be captured in form, "frm_CheckerVerify" is mentioned below.
Code:
RefNos BranchName AccountNos
0001 BRN6 1234567890123
0002 BRN3 1234567890222
0003 BRN7 1234567890444
0004 BRN7 1234567890444
0005 BRN3 1234567890222