I have attached my sample database. If you click on a record on the main screen it will bring you to the Case Details screen. When you click on "create Additional Review" button it creates a new record however the fileno (automatically created) does not change, which is causing a problem. The fileno is the text box to the right of the Act 6 check box. I want that number to change when I execute the macro "create additional Review".
The database does not contain any confidential information.