InfoPath Dev

 1. when are you setting other values in form 2?   every time when opening the form 2, it will run this sql to get all fields value.   Dim sqlString As String = "SELECT * FROM tbl_TemporaryLicence WHERE TempPermitID = " & RegNo 2. Are you getting the correct "RegNo" from your main data source that the ...

Now I have two infopath forms 1 and 2. there is a repeating table in form 1 with a button in each row, when click this button, the form 2 will pop up with more detail information and the value of current row's ID will be sent to the form 2. my problem is nomatter which row i select, the ID field in form 2 is correct, but other fields ...

Finially I made this out. At first for a test I didn't create any data connection for the record form which only has a textbox in  main datasource. Then I tried to connect this form with the database as well and using the following codeDim recordDatasource As DataSource = recordForm.DataSources("tbl_TemporaryLicence") ...

Thanks Hilary I tried your code, and created a textbox named "UserID" in the record template, but there is an error said "Object reference not set to an instance of an object" do you have any idea why Thanks

Hi Patrick thanks for your reply I have created the following code to try :  Public Sub Select_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)      Dim recordForm As XmlForm = Application.XmlForms.NewFromFormTemplate("C:\Documents and Settings\speng\Desktop\Infopaht ...

I am new to infopath. Now I am developing an user interface which is connecting with an test database. what i wanna to implement is that when opening the main form, it will load data from the database automatically (i've already implement that), then i put a button for each record when i click the button there will be come out a new form which ...