Hello All,
I am needing up with coming up with a macro/vba to lookup a value in a table and compare it to a record in a form.
Example below
Master Table/Parent Table
ID AAL Access Level Allowed Access
1 AAL123 Level 1 Access Wire Transfer
1 AAL123 Level 1 Access Paypal
Form has the following columns in datasheet view
UserName AAL Access Verified Access Permission
Johndoe AAL123 Wire Transfer
Johndoe AAL123 Paypal
I would like to run a macro or vba code to lookup the AAL for each record on the form and find it in the Parent Table, once the code fields the id, compare the Access column in the form one with the Allowed Access in the parent table, if it matches then place a fail in the Verified Access Permission Column
so maybe dlookup on the AAL in the Form in the Master/Parent table and compare the Allowed Access for the AAL # with the Access column in the form, if it matches then Pass, if not then Fail
I am needing up with coming up with a macro/vba to lookup a value in a table and compare it to a record in a form.
Example below
Master Table/Parent Table
ID AAL Access Level Allowed Access
1 AAL123 Level 1 Access Wire Transfer
1 AAL123 Level 1 Access Paypal
Form has the following columns in datasheet view
UserName AAL Access Verified Access Permission
Johndoe AAL123 Wire Transfer
Johndoe AAL123 Paypal
I would like to run a macro or vba code to lookup the AAL for each record on the form and find it in the Parent Table, once the code fields the id, compare the Access column in the form one with the Allowed Access in the parent table, if it matches then place a fail in the Verified Access Permission Column
so maybe dlookup on the AAL in the Form in the Master/Parent table and compare the Allowed Access for the AAL # with the Access column in the form, if it matches then Pass, if not then Fail