title: How to open another form within a vba function and return to the function
body: <p>I have a MS Access form with a button that calls a function that starts by checking a date and asks the user if he needs to manually change the date. If this is the case, another form is opened where the date is entered and validated. Is there a possible way to load the selected date into a variable and return to the first form into the function that is running to use it further down the procedure?</p>