Populate controls in a parent form
Ok, this will be kind of long, so please bear with me. I have a form (see below) that allows the user to choose an Agency, and in so doing, the form will display the Venues associated with the selected Agency, as well as offering the option of "New Venue." If the user chooses an existing venue, the database will populate the Venue Details field (see below) However, if the user chooses "New Venue", it will open a pop-up form, and prepopulate the required fields, that will allow the user to enter