InfoPath Dev

Gregs very busy, I'd give him alot of time to respond. Also with a new child it makes it that much harder. :-)

Heres the code i put behind my search. This takes both numbers that im searching between and displays the records inbetween to be changed. function CTRL2_8::OnClick(eventObj) { // Get the default SQL command for the form. var strOrigSQLCommand = XDocument.QueryAdapter.Command; var queryCase = ...

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.

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...

yes it is a full trusted form. I will let you know what I find.

Ok my first thought was to have the submit button look in my file where i have my users saving the xml file if they want to. But the submit has to be programmed if i wanted to add code. Correct?? So I went to the save button on the form. I have this var myPathdelete = XDocument.DOM.selectSingleNode(''/dfs:myFields/my:test''); myPathdelete = new ...

Thanks Greg. I just removed the ''New Record'' for the time being. It created a hassle with something else, that i cant remember so it'll be on the back burner for now. I have it set to make a new record everytime they open the form. Or do a search if they like.

Wow thats seems to have done the trick. Thanks Greg.

Its a SQL connection.

Hmm, i have a small problem with this. Its telling me. ''An item with the following index deos not exist in the collection:Main Connection'' Main connection is the data connection that i need extended. This looks to be a very simple procedure. Because it looks like you create the connection thats to be changed and then chenge it , then submit ...