(Solved) – MS Access 2013 – How to Trigger Event on a Automatically Updating Textbox

(solved)-–-ms-access-2013-–-how-to-trigger-event-on-a-automatically-updating-textbox

I have been banging my head against the wall for a while trying to get this to work. I have an Access 2013 database. The db has a sub-form with a RecordID, Business Name, and Primary Contact in a continuous form. I have the active record being highlighted at this point. The RecordID, Business Name, and Primary Contact fields are being passed up to the parent form so they can be used later for other sub-forms/purposes. I have a text-box in the middle of the parent form that I want to show the active record name in. If the business name is empty I want to display the primary contact name and if the primary contact name is empty I want to display the business name. I have gotten the if statement to work if i put the code in the OnClick event and I click on the RecordID text-box. Is there a way to trigger the event when the RecordID automatically changes without my interaction with the RecordID text-box. Thanks in advanced

Leave a Reply

Your email address will not be published. Required fields are marked *