Good afternoon, I am working with a navigation form. I know not a lot of people like the use of the navigation forms, but this is the best organized way to display my information. When clicking on a navigation button, I have a form that opens. One of the forms needs information from a popup form before populating. (The navigation form has multiple lists based on the popup form information). How do I pause the opening of the navigation form, allow the end user to complete the information in the popup form and then click a cmdbtn on the popup form to open the form with the necessary information in the navigation form? I want to keep the popup form open as it is needed for other vba executions. I have tried to use the onOpen cancel=vbCancel which does cancel the loading of the form, but don't know how to reload the form within the navigation form. It opens it in full form mode. I cannot open the navigation form without it looking for the information needed in the popup form and is giving the end user the the "Enter Parameter Value" window.
Navigation Form: Forms![frmNavMain]![frmNavMain].Form![frmLogService]
Popup Form: frmLogServicePopUp
Currently the cmdbtn is set to reqry the designated form. Just need the loading of the form to pause until the information is inputted.