Hi Mike,

If "Projects" is the name of your secondary data source,
thisXDocument.DataObjects("Projects").Query() should work.  What happens when
you use that code?
Read this post (it is C#, but it is the same issue):
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=457

Regards,

Franck Dauché

I am using managed code to allow a user to add values to a dropdown list.

I have a repeating table which includes a dropdown list and some text boxes.
It also icludes a button to allow the user to add an entry to the dropdown
list. The data source for the dropdown list is an Access table.

When the user clicks the button, the form switches to a view which contains
a text box in which the user enters the new value for the dropdown. The user
then clicks a button. My vb.NET code adds the new value to the Access
database table and switches the view back to the repeating table. The managed
code uses  thisXDocument.DataObjects("Projects").Query() and  
thisXDocument.View.ForceUpdate() in the OnSwitchView event to repopulate the
dropdown.  

The new entry is shown as the selcted value in the dropdown, and it also
appears in the list for the dropdown. This is exactly what I want to happen.

HOWEVER, when the user adds a row to the table and drops the dropdown list
down, the new value is not in the list. The value is still in the dropdown
for the first row, and it is in the Access table.

I tried using the thisXDocument.DataObjects("Projects").Query() and  
thisXDocument.View.ForceUpdate() in the OnContextChange event because that
event fires when the row is added to the table. That did not help.

Strangely, when I traced the OnContextChang event, the
thisXDocument.DataObjects("Projects").Query() executed, but when I stepped
the code, it did not go to the next line, which is the
thisXDocument.View.ForceUpdate(). It apparently just exits the subroutine.

I am new to InfoPath and managed code, and it has taken me a lot of effort
to get this far. I would greatly appreciate help with this last step.
 Was this post helpful to you?      

I found that if I put a button with a Refresh action on the main view and
click it after I return to that view, the new list item appears in the
dropdowns for all repititions - as it should. That was why I was asking how I
could do that programmatically. It looks like I must have my "Query" in the
wrong event or something.