Hey guys, I am new to Access and am wondering how one might go about programing a form that will auto-fill information into a TextBox when a specific record is selected from a ComboBox, but when no record is selected allow me to put in new information.
I am designing a database that tracks contracts between medical institutions (facilities) and a university. Some facilities have the same contract information because they are owned by the same parent company, while others have no parent company, therefore unique information. I'd like to be able to have the contract information from facilities, who have the same contract information, to be auto-filled by selecting a value from a ComboBox that lists all of the parent companies, but still have the ability to input new information myself for facilities who have no parent.
I have tried using If Then Else statements with no success. If anyone has an idea of how I should go about creating this it would be very much appreciated as I have reached the the limits of my knowledge about Access.