I've been searching for an answer to my specific problem, but I've finally conceded defeat and need some assistance (I'm still relatively new to VBA). I have a database that tracks exceptions for different loans. The loan record is in one table and the exceptions are in a different table because there can be multiple exceptions per loan. These tables are tied together by the loan number.
The end users, however, have a form to key the loan record and any accompanying exceptions. That form ("Loan Tracking Form") is using a subform (the Exceptions table) and, like the tables, are tied together by the loan number. In a perfect world, we would enter the correct loan number every time. However, if a user has to change the number of the loan, I need to find the appropriate code to loop through my Exceptions table, identify all exceptions that were tied to that loan record, and change the loan number to match the new loan record so they don't become detached from the record. Is that enough information for those of you with vastly more knowledge than my own to help me?
The end users, however, have a form to key the loan record and any accompanying exceptions. That form ("Loan Tracking Form") is using a subform (the Exceptions table) and, like the tables, are tied together by the loan number. In a perfect world, we would enter the correct loan number every time. However, if a user has to change the number of the loan, I need to find the appropriate code to loop through my Exceptions table, identify all exceptions that were tied to that loan record, and change the loan number to match the new loan record so they don't become detached from the record. Is that enough information for those of you with vastly more knowledge than my own to help me?