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 / March 2007

Tip: Looking for answers? Try searching our database.

Passing a variabl to SQL code

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joanne - 08 Mar 2007 19:31 GMT
Hello, I have a question about a drop down box.  The user picks a name from
the drop down and then, based on that value, the query button is supposed to
pull up other fields.  I want to use the value in the drop down box as a
WHERE statement in the SQL code but I don't know how to capture that
variable.  Thank you very much for your help.
Zhang Haiguang - 09 Mar 2007 03:36 GMT
You could add a rule to the drop down box, then add a "Set a field's value"
action
into the rule. Set the value of the drop down box to one of the fields
submitted by the query button in the action.
http://www.infojetsoft.com

> Hello, I have a question about a drop down box.  The user picks a name
> from
[quoted text clipped - 3 lines]
> WHERE statement in the SQL code but I don't know how to capture that
> variable.  Thank you very much for your help.
 
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.