Code

Re: Conditional statetment for controls...

pablavo — Thu, 30 Oct 2008 09:29:29 GMT

I'm very pleased I found this site, thanks for all your help folks, I'll give both a try a and tell you how I got on...

Paul

Re: Conditional statetment for controls...

Shiva — Thu, 30 Oct 2008 06:55:25 GMT

Hello,

If you want set the 4 text box values depending on the selection using code follow this steps.

Insert onAfterChange event for dropdown field.

In onAfterChange event you have to write the below code,

string dropdownValue = e.site.Value;

//Secondary DOM is contains of text box values

//Get the textbox1 value form secondary dom

string textbox1Value = secondaryDOM.selectSingleNode(string.Format("<XPath of your field>", dropdownValue));

//Setting the value to text box1

XDocument.DOM.selectSingleNode("<XPath of textbox1>").text = textbox1Value;

Note: Like this you can write for 4 text box values.

Re: Conditional statetment for controls...

Rajitha — Thu, 30 Oct 2008 05:46:33 GMT

Hi,

Here is the link to populate the values depending on the selection of dropdown with out using code.http://www.infopathdev.com/blogs/matt/archive/2006/04/18/Automatically-Populate-Fields-from-a-Drop_2D00_Down-Selection.aspxHope this helps you.

Conditional statetment for controls...

pablavo — Wed, 29 Oct 2008 14:33:33 GMT

Hi folks,

Hope someone can help. I'm fairly new with InfoPath and I've got a question about controls.

Im going to use arbitrary names for simplicity.

There is a drop down list on my form. When a selection is made I'd like 4 other text boxes to show related values depending on the selection made. a bit like a case or If... then statement in Access.
I really don't know if this is possible. really what's happening is, the text boxes are using a lookup table from the database and the code (or another method) will insert the values into the form, when submitted, the correct values that are related to the drop down value will be added to the database.

Does anyone know if this is possible? If you need more info let me know. I've put an VBA case statement below to clarify what I mean to do.

study = Me.StudyID 'Drop down list'

    Select Case study
        Case 1
            Me.Milestone1 = 1 'Text boxes'
            Me.Milestone2 = 2
            Me.Milestone3 = 3

        Case 2
            Me.Milestone1 = 4
            Me.Milestone2 = 5
            Me.Milestone3 = 6
        Case 3
            Me.Milestone1 = 8
            Me.Milestone2 = 9
            Me.Milestone3 = 10


Me.Milestone1.Requery
Me.Milestone2.Requery
Me.Milestone3.Requery
    End Select