Solved

Forms: Choosing a field in dropdown box will show other textfield

Posted on 2002-07-12
4
213 Views
Last Modified: 2010-04-08
Hi,
I'm developing a helpdesk form
This is what i want to do:
I have a dropdown box with 2 values (contractor or own employee). Own employee is the default value. If contractor is chosen a textfield must appear.
I've created the dropdown box (name = EndUserType) and a textfield (name = ExpirationDate). My Outlook Version is 10.0 (Outlook 2002). I don't have a code yet. Hope anybody want/can to help me!
0
Comment
Question by:Marie-Anne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:jessnjeff
ID: 7150678
put the code to make the textfield.visible = true in the Custompropertychange event of the form.

post back if you need further details on proper syntax
0
 

Author Comment

by:Marie-Anne
ID: 7151120
I'm just a newbie, so if you could give me more information about the custompropertychange event... It would help me a lot!
0
 
LVL 8

Accepted Solution

by:
jessnjeff earned 300 total points
ID: 7158340
Okay....
1.  dropdown box field is called EmpStatus
2.  textfield is called MyText


Sub Item_CustomPropertyChange(ByVal Name)

'Get formpages
     Set curpage = Item.getinspector.modifiedformpages("P.2")<----This is the page on which the control is located.  If you used the first one in a message form, it is usually called "Message"
     
'Get controls
         Set myControl = curpage.Controls

     Select Case Name
          Case "EmpStatus"
                myControl("MyText").visible = true
        End Select
End sub

0
 

Author Comment

by:Marie-Anne
ID: 7162297
Thanks! you helped a lot!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question