lookforsmt
Registered User.
- Local time
- Today, 15:25
- Joined
- Dec 26, 2011
- Messages
- 672
HI! This has been raised numerous time with solutions, but i am still confused on how to apply to my db.
I am looking to validate my input based on 3 criteria's. I one of them don't match the status flag should be "UnMatch"
To give brief background of my db:
my db has "tbl_Master" which will have all the valid records then,
db has "tbl_temp_Validate" which will be used to capture datas (3 Fields):
MICR_Scan
CreditAC
Amount
In form "frm_ChqScanValidation" linked to subform "subfrm_tempValidation" i will be capturing these 3 fields.
On the AfterUpdate event it generates data in field MICR after i capture in field MICR_Scan. Currently it gives me popup msg "Incorrect MICR Scanned" but the details are correctly mentioned in "tbl_Master". Secondly i dont know how to validate 2nd and 3rd fields.
Any suggestions pls help.
i am attaching my db in case above is not clear.
There is a Sample table which is used for capturing data. I copy the MICR_Scan; CrediAC & Amount respectively for capturing data in form "frm_ChqScanValidation"
I am looking to validate my input based on 3 criteria's. I one of them don't match the status flag should be "UnMatch"
To give brief background of my db:
my db has "tbl_Master" which will have all the valid records then,
db has "tbl_temp_Validate" which will be used to capture datas (3 Fields):
MICR_Scan
CreditAC
Amount
In form "frm_ChqScanValidation" linked to subform "subfrm_tempValidation" i will be capturing these 3 fields.
On the AfterUpdate event it generates data in field MICR after i capture in field MICR_Scan. Currently it gives me popup msg "Incorrect MICR Scanned" but the details are correctly mentioned in "tbl_Master". Secondly i dont know how to validate 2nd and 3rd fields.
Any suggestions pls help.
i am attaching my db in case above is not clear.
There is a Sample table which is used for capturing data. I copy the MICR_Scan; CrediAC & Amount respectively for capturing data in form "frm_ChqScanValidation"