>Hello All,
>
>I have a form with a field for a memo. When the field is double-clicked it opens a new form in a private data session which allows the user to enter the information into the memo field. I pass the current value of the memo field to the new form. How do I pass the modified value back to the calling form. I'm sure this is a stupid question, but it is one I am past answering at this time. Any help will be greatly appreciated. Thanks in advance.
>
>Andy Ahrndt
>Computer Management Sciences, Inc.
>aahrndt@mindspring.com
Hi Andy,
Although Edward and Nick answered your question with appropriate tips, here's my own answer.
If you want to design a form that's supoosed to return a value (your second form returns something to the first form), you should make it modal.
Add a custom property to it, e.g. MyMemo. Assign this property with the value of your memo field. In your Editbox, work with the MyMemo property. When you're done with your second form, include the RETURN (ThisForm.MyMemo) in the Unload() event. This is probably what you want to do.
Having said this, does not mean that this is the way I would do it. I always work the way Edward mentioned.
pat