IF statement in VBA

[rlsublime]

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

[mejia.j88]

If this is to update records, i suggest:
http://office.microsoft.com/en-us/ac...010076527.aspx