dynamically display data after selecting different entries of a drop-down list without hitting Run Q

[nguyen.katy]

My form is based on a database. The user must select a project ID to
be able to view its data. The IDs are populated based on a secondary
data source through a drop-down list control. Currently, the user can
view the project details after selecting an ID from the drop-down list
and hit Run Query button.

I would like to get rid of this Run Query button so that after
selecting an ID , the project details are populated automatically into
the datafields which the user can modify and submit back to the
database.

Any help is much appreciated.

 

[Greg Collins [InfoPath MVP]]

You can use a rule on the drop-down to do the query. This will then requery every time the drop-down value is changed.

 

[nguyen.katy]

OH, I've been using "Set a field's value" instead of "Query using a
database connection".

Thanks a lot!!