Getting data from another form

  • Thread starter Thread starter Blue
  • Start date Start date
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
 
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.
Click to expand...
You need to create the confirmation item as a response to the form that
Sue reads the message with. The trick to designing the confirmation form
is to drag those three fields from the category of fields that is named
the same as the published form the Sue uses. Doing it that way, the
fields are autoloaded when the confirmation item is created from Sue's
message.

In the outlook development books, this usually referred to as form1 and
form2, where form2 is the response to form1. You can kick off the
creation of form2 with a command button that you put on the form and put
code behind it, or request the form1 automatically include a button to use
when you specify the custom response/action. Be sure to look up what you
book says about auto-loading, and also check the help file of your current
version of Outlook for that term.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2600
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA
 
Back
Top