I have a form that opens depending on whether a specific selection is made in
a combo box in another form. I would like to be able to run a line of code
in the On Change event of that combo box after this new form is open, but do
not want the user to be able to do anything else unless they close this new
form (hence the dialog window mode).
You can get some 'Modularity' by using Forms!YourForm.Modal = True but not
the same as opening the Form acDialog. What you want can probably done
using Windows API functions but I would not recommend it as turning a
non-dialog form into a dialog is just not normal program flow.
HTH
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.