Outlook - custom contact form formulas

  • Thread starter Thread starter DianaJDixon
  • Start date Start date
D

DianaJDixon

I'm customizing the contact forms for our company and I'm trying to create a
field that will show what accounting products each of our clients have. I
currently have "check box" fields that our sales people click to indicate
which products are being used - however the new field I am trying to create
is for their monthly reports. I would like a field that will give a list of
the names of each product when that product's check box is clicked. I've
gotten as far as getting my formula to work for one product, but can't seem
to get my formula working if I add anything else to it...
Please help!

IIf([Time Capture Used: AderantExpert]=Yes,"Aderant Expert")

(in the quare brackets is my field; when clicked I want Aderant Expert to
show in this new field)
 
This is probably best posted "down the hall" in microsoft.public,outlook_vba.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, DianaJDixon asked:

| I'm customizing the contact forms for our company and I'm trying to
| create a field that will show what accounting products each of our
| clients have. I currently have "check box" fields that our sales
| people click to indicate which products are being used - however the
| new field I am trying to create is for their monthly reports. I would
| like a field that will give a list of the names of each product when
| that product's check box is clicked. I've gotten as far as getting my
| formula to work for one product, but can't seem to get my formula
| working if I add anything else to it...
| Please help!
|
| IIf([Time Capture Used: AderantExpert]=Yes,"Aderant Expert")
|
| (in the quare brackets is my field; when clicked I want Aderant
| Expert to show in this new field)
 
I've never used VBA, nore do I know how to, is there no formula I can use
when designing a custom form?
 
Back
Top