I have created a form "Transactions" for data entry. One field, "Account", selects from an existing list, but can accept new Accounts. When I accept a new account, I would like to be prompted to go to the "Account" form and fill in the Account description on 4 additional fields (Title, Category, Requester, Date). Once this done, I would like to return to my initial "Transactions" form to fill in additional information.
I use Access but I am not a programmer. Can you help me with detailed codes on how to do this?