Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   Populate Company field from Contact field in custom task form (http://www.outlookbanter.com/outlook-using-forms/5483-populate-company-field-contact-field.html)

Sue Mosher [MVP-Outlook] January 20th 06 07:37 PM

Populate Company field from Contact field in custom task form
 
You'd have to write code to populate that field, not use a formula. The example at
http://www.outlookcode.com/codedetail.aspx?id=566 is for VBA not form code, but it shows the basics of how to use the Links collection for this.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Dave C." wrote in message oups.com...
Using Outlook 2002 or 2003, creating a custom Outlook form based on the
Outlook default Task form. On page 2, I want to select a contact from
the Contacts folder. Then, I want a second field COMPANY to
automatically populate with the chosen contact's company name. I've
been through the Help file, online searches, and an Outlook book and I
think it's too simple to even be an example. But no matter how I set up
the Value and Validation properties of the Company text box, I cannot
get it to do the lookup and auto-populate. I have unsuccessfully tried
placing the Contacts and Company control and fields on a frame, and
also tried to calculate the value using a formula. Any idea what I am
doing wrong?

Controls and fields were dragged and dropped from Field Chooser,
Frequently-used fields. Properties of these fields:

CommandButton1:
(Choose Field): Contacts
(Type): Recipient

_RecipientControl1
(Choose Field): Contacts
(Type): Recipient

TextBox13
(Choose Field): Company
(Type): Keywords
(Property to use): Value



All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com