Getting data from another form

B

Blue

Hello All,

I was wondering if it is possible for a form to pull data from another form.
For example say I created a form that had three text fields (name, date, and
reason). So let's say Sally would fill this form out and send it to the
proper person(Sue)...Once Sue reads the form she needs to send a
confirmation form back to Sally...So instead of Sue having to re-create all
the information, I want the Conformation form to pull the information from
the form that Sally created...Is this possible? If it is how can it be
done? Any resources or explanation of how this can be done is very much
appreciated....Thank you in advance.

BLUE
 
B

BLUE

Anthony,

Thank you for the suggestion, but I'm really not trying to go that route...I
want to make this as simple as possible...Any other suggestions Anthony or
anyone else?
 
E

Eric Legault [MVP - Outlook]

I would put code in the original form that is activated by a custom menu/button. Call it "Send Confirmation". When the recipient receives and reads the form, they would click it and this would then create an instance of your confirmation form. Your original form will contain the code that has programmatic access to the data stored in itself, as well as the fields/properties of the new confirmation form. Just don't display it until you've populated it in code.
 
B

BLUE

Eric,

Do you know of a book, other reference, or sample code that explains step by
step on how to do this?

Eric Legault said:
I would put code in the original form that is activated by a custom
Click to expand...
menu/button. Call it "Send Confirmation". When the recipient receives and
reads the form, they would click it and this would then create an instance
of your confirmation form. Your original form will contain the code that
has programmatic access to the data stored in itself, as well as the
fields/properties of the new confirmation form. Just don't display it until
you've populated it in code.
 
E

Eric Legault [MVP - Outlook]

The Outlook VBA and Form help files are your first point of reference, as well as MSDN.

Also see http://www.outlookcode.com and check out Sue Mosher's book.

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/



BLUE said:
Eric,

Do you know of a book, other reference, or sample code that explains step by
step on how to do this?

Eric Legault said:
I would put code in the original form that is activated by a custom
Click to expand...
menu/button. Call it "Send Confirmation". When the recipient receives and
reads the form, they would click it and this would then create an instance
of your confirmation form. Your original form will contain the code that
has programmatic access to the data stored in itself, as well as the
fields/properties of the new confirmation form. Just don't display it until
you've populated it in code.
Click to expand...
 
Top