Pause form from opening until information in popup form complete

[mlrucci]

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.

[Bob Fitz]

Can you post a copy of the db

[mlrucci]

Here is a very stripped down version


Database1.zip

[moke123]

Set the rowsource of the lists in the click event of the popup.

[mlrucci]

unable to place the rowsource to the popup as each list has different information. unclear what you are thinking

[moke123]

I was too lazy to copy your list rowsource queries so I saved them as Q1,Q2,Q3,Q4.

Private Sub cmdSubmit_Click()
    Forms!frmNavMain!frmNavMain.Form.lstMonth0.RowSource = "Q1"
    Forms!frmNavMain!frmNavMain.Form.lstMonth1.RowSource = "Q2"
    Forms!frmNavMain!frmNavMain.Form.lstMonth2.RowSource = "Q3"
    Forms!frmNavMain!frmNavMain.Form.lstMissingEntries.RowSource = "Q4"
End Sub

here's your example with the above code.

[mlrucci]

Wow, so simple. Have spent hours thinking and playing with so many variables that I think my head has twisted off. lol Thank you very much!!!

[moke123]

You should also have option explicit declared in each of your modules.

good luck with your project.