InfoPath Dev

 Hi, I am trying to create a search function in InfoPath. (Just want to search a SharePoint List)

I have created a search button, which works, and it gets the results from a sharepoint list... I have added a repeating table to the form.

 The issue I have is that when the form loads, All the values in the list are shown in the repeating table.....

 How can I have it so that when the form loads, the repeating table is Blank, and results are only shown when a query is made?

 Thanks

 You'll need a button to query the external Sharepoint list, which you already have.

You need a formatting rule on your repeating table section so that if your 'search query box' "is not equal" to a field in repeating table, hide control

You'll need to playing around with the rule to fit your search criteria etc.

could you please share me the steps to populate repeating on search button.

 What type of data source are you searching SP List or something else.

 The most recent one I've done was looking into an SQL database. I used the following code on a SQL view - brilliant

 http://social.msdn.microsoft.com/Forums/sharepoint/en-US/5aa4519c-b8e0-4a7c-85b4-09f7e1d0747a/dynamic-sql-data-connection-in-InfoPath