InfoPath Dev

 Hi All, I have a form that pulls data from other forms in a document library. On opening the form pulls all title from the forms in the document library and loads them into a drop down list. My problem is once the user selects the desired title and hits the cooresponding submit button I do not know how to create data connection query that ...

 Thank you both for the help, I was able to use the solution suggested in Shiva's post.

Hey, I am trying to populate a date picker from the code behind but when trying the code below I receive the following error: System.InvalidOperationException Schema validation found non-data type errors. Dim depart_date as String = "2009-02-04" Dim nav As XPathNavigator = ...

 hmm... I changed the data binding from queryField to dataField and it worked correctly but it caused my Sum() formula to stop firing.

 Thanks joanne that is exactly what I was doing.

I am using 1 table, I had multiple tables that were joined through foreign keys but it would not allow me to have 'Enable submit for this connection' checked. I tried removing the textbox and replacing it with a new one but still the same result. It is very odd, I tried creating a new form and new SQL connection but still the same result.

Thanks for the reply Swathip, I have the 'Submit' setup as your described above and it works correctly but my issues is it will only submit the first textbox. Say I create a form with 2 textboxes and have the both binded to rows in a database well when I preview the form, add content into the textboxes and then click submit; only the ...

Hey all, I am new to InfoPath and have been doing a lot of trial and error to get my feet wet. Currently I am trying to work with a SQL database. I can populate a form with multiple textboxes fine but when I try to submit (using a button, action: 'Submit') a form with multiple text boxes it only submit the information in the first text box ...