https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/118539.aspxFri, 16 Mar 2018 15:07:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118539Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118539.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=118539When you say choice options, can you tell me more about what you mean? Is this a dropdown control? And the values available need to be combined from different lists? In general, we can only use one data source to provide options to a dropdown. If the difference is the data source used to provide the values, you could have a number of dropdown controls, bound to the same field, with different data sources for the options, and logic to show / hide the control based on other conditions, but I don't think this is quite what you are asking. If you need to merge data sources, you'll have to use code - which can't be used in some types of forms (like SharePoint list forms).https://www.infopathdev.com:443/forums/thread/118528.aspxThu, 15 Mar 2018 15:18:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118528Jim Li0https://www.infopathdev.com:443/forums/thread/118528.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=118528I have a choice control that has several values. But I want to hide different options based on different users. Is it possible? More specifically, the options are gathered from 3 or 4 lists and need calculation. So the real question is, is it possible to dynamically generate choice options? The options cannot be stored in SharePoint list because each user open the form, the choice options will be different.