 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / August 2007Two linked drop-down list boxes
I wonder who could help me with this? I've got two drop-down list box and I would like that the value selected in the first one determines the values chosen in the second one. Could anyone give me the details on how to do it plus the code? Thank you, Marc Hey Marc You can acutally do this directly in InfoPath without any code. Set your first Drop Down box to retrieve the list of values you want then in your second Drop down box when you select the field to display you can also set a filter for the data that is being displayed. As long as the data source your using for DD2 has a relationship of some type to the data that is selected in DD1 you can filter the values that are selected e.g. DD1 Data source ------------ Authors ------------ John Smith Jane Smith Maryanne Ellis DD2 Data source ------------ ------------------- Authors Books ------------ -------------------- John Smith Spots First Walk John Smith Spots Second Walk Jane Smith 101 things to do with Meat Jane Smith Cooking For Dummies Maryanne Ellis The idiots gude to Drinking Cofee so when you map DD1 to the first Data source you set it's display value to be Authors When you map DD2 to the second data source you set it's display value to be Books but with a filter that says when Authors = DD1.DisplayValue If you need more info let me know and I'll throw a blog post up with some screen shots Cheers Ben > I wonder who could help me with this? > [quoted text clipped - 5 lines] > > Marc i am also interested in this. i want the equivalent of an IF-ELSE function in excel. i have two drop down lists next to each other on the same row. if you select an item in the first box it automatically selects an item in the second box. could you explain how to do this or does each drop box selection have to made separately, which i already have set up. > Hey Marc > You can acutally do this directly in InfoPath without any code. [quoted text clipped - 43 lines] > > > > Marc Thank you Ben for your help. I see what you mean but I've been trying unsuccessfully to do it. This is why I wonder if you could give me some more details or send me a sample file (this would be the best option). My email address is cosmic_spanda@hotmail.com Because mgraye is also interested if he or she sends me a message to this address I will transfer the sample file. I reckon this would allow us to understand how it works. Thank you very much again and I hope ti hear from you again either in the newsgroup or at my address. All the best, marc Marc I have sent through a sample .xsn file with a filtered drop down for you to look over, I will also put a step by step guide on my blog http://msmvps.com/blogs/benwalters/default.aspx so you can walkthough how I did it Cheers Ben Walters > Thank you Ben for your help. I see what you mean but I've been trying > unsuccessfully to do it. This is why I wonder if you could give me some more [quoted text clipped - 11 lines] > > marc Hi Ben..., If you have time, I'd also appreciate a sample of the .xsn as well. Please send to dobrikat@carolina.rr.com. thanks so much in advance. D ---------- > Marc > I have sent through a sample .xsn file with a filtered drop down for you to [quoted text clipped - 20 lines] > > > > marc |
Reply to this Message |
 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.