Passing Values Between Forms

[David Burkhart]

A button on form-1 calls form-2 (modal) where a value is selected from
a listbox. How do I pass the selected listbox value back to form-1?

drb

 

[Al Camp]

On the AfterUpdate event of Form2 Listbox, in the Form2 module...
Forms!frmOne!YourTextControl = Me.YourListboxName
hth
Al Camp

 

[Albert D.Kallal]

You can have the form set as many values as you want in the close event.

If you need the ability to halt the code, prompt user..and then continue,
then I explain how to do this here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

 

[David Burkhart]

On the AfterUpdate event of Form2 Listbox, in the Form2 module...
Forms!frmOne!YourTextControl = Me.YourListboxName
hth
Al Camp

Al --

Thanks for the idea. At this point I think Albert K's idea below will
work better as it would be great if I could stop the code while form2 is
open. I'll play with both ideas.

drb

 

[David Burkhart]

You can have the form set as many values as you want in the close event.

If you need the ability to halt the code, prompt user..and then continue,
then I explain how to do this here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

Albert --

Halting the code sounds like just the ticket. I'll try it out. Thanks
for the ideas.

drb

 

[David Burkhart]

Albert --

Halting the code sounds like just the ticket. I'll try it out. Thanks
for the ideas.

drb

Halting the code works great! Thanks. Now to clean up all the odds and
ends from my trials!

drb