There are two tables (Repurchase and Investor_request). Both have a common loan number. I am trying to write a vba if/then code to do the following:
if(Repurchase![Loan Number]=Investor_Request!Loan_Number And Investor_Request!STATUS="Outstanding" then change status of Investor_Request!STATUS="Closed")
Thanks a lot