Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / September 2005

Tip: Looking for answers? Try searching our database.

Automatically refreshing list in drop-down list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eric - 31 Aug 2005 14:57 GMT
I have a list that is coming from the database, is there anyway that I can
automatically refresh the query so that if a new row is inserted through
InfoPath, that list will imediately show the change.

How would I do that?
Greg Collins [InfoPath MVP] - 01 Sep 2005 00:20 GMT
You need to re-query your data souce. This can be done via a button or code.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

I have a list that is coming from the database, is there anyway that I can
automatically refresh the query so that if a new row is inserted through
InfoPath, that list will imediately show the change.

How would I do that?
Eric - 01 Sep 2005 14:38 GMT
If I have a query button, it then will display all of the results on the
page.
You need to re-query your data souce. This can be done via a button or code.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

I have a list that is coming from the database, is there anyway that I can
automatically refresh the query so that if a new row is inserted through
InfoPath, that list will imediately show the change.

How would I do that?
Scott L. Heim [MSFT] - 01 Sep 2005 21:12 GMT
Hi Eric,

You can setup a Rule so that you only query the secondary data connection:

- Right-click on your button and choose Properties
- Click the Rules button
- Click Add
- Click Add Action
- From the Action box choose: Query using a data connection
- From the Data Connection box, choose your secondary data connection

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.