Popup Box

[bwilcox]

Hello,

1. I open a form that will open a second form. - DONE via
DoCmd.OpenForm

2. On the second form, select data from a dropdown
combobox - DONE via OnChange Event

3 Question - How do I pass the selected data to the first
form and for use thoughout the project?

4. Question - Change focus to first form?

5. Question - Close second form?

Thanks

 

[Tom McDonnell]

3. Try storing your value in a global variable - create a
new module and declare a Public variable. You will be able
to reference this global var from any form in your project.

4. use SetFocus to change back to first form

5. DoCmd.close - not sure how that will work out with
changing the focus, but play around and I'm sure you'll
get it to work.