Changing Data Connection Query [InfoPath 2007]

[James Laker]

With such a lack of tutorials on the web, anyone have links to proper
Infopath 2007 tutorial where I can find out how to change a Dataconnection
Query and Execute it from Code.

I'm trying to update an Combobox by retrieving only the current user's
Awards when the form loads.

Thanx a lot in advance!

 

[S.Y.M. Wong-A-Ton]

It sounds like you want to filter a combo box. If you've bound the combo box
to a data connection, you can retrieve the items for that data connection in
code, filter the items, and then refill the combo box. The principle behind
combo boxes is the same as that behind drop-down list boxes. This article
http://enterprise-solutions.swits.n...populate-drop-down-list-box-infopath-2007.htm
explains the concept for filling drop-down list boxes in InfoPath. And this
document
http://www.microsoft.com/downloads/...D9-0A31-45DE-8EFB-16C75E194DC3&displaylang=en contains a section on how to filter.