Watch how I create a form to allow us to add new borrowers to the database, including the how to create a combo-box. For more information about Access and a free booklet on these techniques: https://www.advanced-ict.info/databases/access.html
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.
