InfoPath Dev

Hi,

I have a repeating table in my infopath form.I would like to know is there a way to clear a single field in one instance of repating table.Because if i clear one field using a rule or code,it is applying to all instances of repeating table. 

it is possible to clear a particular instance of a field in repeating table using code.

XPathNodeIterator listItemNav = this.MainDataSource.CreateNavigator().Select("my repeating table path", this.NamespaceManager);

listItemNav.Current.SelectSingleNode("field_name", this.NamespaceManager).SetValue(string.Empty());

}

 Hi Qazi,

Thanks for your reply.I tried to do the same as you guided.It is clearing the field.But not the field related to that Repeating table instance.Clearing the field of the first instance only.

' Write your code here to change the main data source.

'path.SelectSingleNode("/my:ContractRequest/my:Titles/my:Details/my:ISBNDetails/my:CRFH_Title1", Me.NamespaceManager).SetValue("")

Dim i As Integer

Next

End Sub

Hi all,For this thread this is the code i figured out working well.Thanks again qazi.

Public Sub SelectCustomer_Changed(
   ByVal sender As Object, ByVal e As XmlEventArgs)
   Try
      ' Get a reference to the Customers secondary data source,
      ' and create an XPathNavigator object for it.
      Dim Customers As XPathNavigator = _
         Me.DataSources("Customers").CreateNavigator

      ' Create an XPathNavigator object positioned on the current site,
      ' which is the SelectCustomer node in the main data source.
      Dim myForm As XPathNavigator = e.Site.CreateNavigator

      ' Move to the parent of the SelectCustomer node, so that the code
      ' can access the CustomerName node.
      myForm.MoveToParent()

      ' Check if the user selected the blank value from the
      ' Drop-Down List Box after previously selecting a CustomerID.
      If e.Site.InnerXml = "" Then
         ' Clear previously selected value from CustomerName field.
         myForm.SelectSingleNode("my:CustomerName", _
            Me.NamespaceManager).DeleteSelf()
      Else
         ' Get the Company name from the Customers data source using
         ' the value in the CustomerID node.
         Dim custName As String = Customers.SelectSingleNode( _
            "/Customers/Customer[CustomerID = '" & e.Site.InnerXml & _
            "']/CompanyName", Me.NamespaceManager).InnerXml

         ' Select the CustomerName node for the current row
         ' and set its value.
         myForm.SelectSingleNode("my:CustomerName", _
            Me.NamespaceManager).SetValue(custName)
       End If
   Catch ex As Exception
      MessageBox.Show("Error: " & ex.Message)
   End Try
End Sub

' Write your code here to change the main data source.

'path.SelectSingleNode("/my:ContractRequest/my:Titles/my:Details/my:ISBNDetails/my:CRFH_Title1", Me.NamespaceManager).SetValue("")

path.Current.SelectSingleNode("my:CRFH_Title1", Me.NamespaceManager).SetValue(String.Empty)

Next

you needed to give the relative path, you were giving the full path