>I have a form (Form_A) from which I create an instance
>of Form_B and SHOW it using the Modal switch.

The usual method of returning a value from a modal form is either make the
value a public variable or property within the modal form, then call the form as such:

' show the modal form
Form1.Show vbModal, me
' get the value from the form
myvalue = form1.MyValue
' now unload the modal form
Unload Form1

In your modal form (Form1), do not UnLoad the form when the user closes it. Hide it instead.

Best,

jody