InfoPath Dev

You need to use the XML Object Model and XPath to access your values. You have a field to which the drop-down list is bound. That field holds the selected value of the drop-down list. So you would do something like: XDocument.DOM.selectSingleNode(''/my:myFields/my:DropDown1'').text Greg Collins [InfoPath MVP]

I'm not much of a SQL person yet, and I'm assuming you are using SQL to store these 130,000 records. But it seems to me that if you have the beginning number and ending number for the range you want that you should be able to build your query in code and then call the Query() method to retrieve your records. I.E. query = * WHERE CASE >= TEXT1 ...

I have created an Infopath form and I am writing a procedure in vbscript to do some calculations. In order to complete the calculations, I need to use the values from my form's drop down list box and text box. How do I access the form controls' values/properties in Infopath with vbscript? (ex: with Access one would use VBA to do it like this: ...

I have a form that i want to retrieve maybe 50- 100 records out of 130,000. each record has a ''Case'' number. I want to be able to query from a begining case number<text1> to case number <text2>. And have it return the 75-100 records to be amended.

Please provide more details. I don't understand what you mean by ''query between two text boxes''. Greg Collins [InfoPath MVP]

Cool! Glad you got it worked out! Greg Collins [InfoPath MVP]

I need to query between 2 text boxs. There both going to have nothing but number in either one. How would i go about doing this? Ive tried to have custom text boxs but i'm not sure how to wuery between the two numbers...

Basically in my DDL2-DDL4 I can now select the ListItem, but upon selecting it I receive the error ''this value cannot be modified''. What exactly does this error mean? I have other DDLs on the page that I am allowed to change and the error doesn't display. The value is an ID and the Name is a string (which is what actually display in DDL2-DDL4. ...

I'm glad your main issue was fixed. Without more details I doubt I can help on the error message you are receiving. Greg Collins [InfoPath MVP]