https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/28700.aspxTue, 13 May 2008 14:25:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:28700vision0https://www.infopathdev.com:443/forums/thread/28700.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=28700<p>sweet i used a varchar instead of char in my table and that fixed the problem thanks</p>https://www.infopathdev.com:443/forums/thread/28686.aspxMon, 12 May 2008 14:01:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:28686Clay Fox0https://www.infopathdev.com:443/forums/thread/28686.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=28686<p>I would add some expression boxes bound to the same fields and verify what is being returned.</p> <p>What field types are you using in SQL?&nbsp; I have seen with non-variable field types that the data gets padded with spaces but then when imported back in that is not an exact match with the dropdown value and therefore it will not show it.</p> <p>But just display the data not in a drop down and verify it exactly is where I would start.</p>https://www.infopathdev.com:443/forums/thread/28660.aspxFri, 09 May 2008 19:31:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:28660vision0https://www.infopathdev.com:443/forums/thread/28660.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=28660<p>i have&nbsp;a few dropdown controls with which i entered my values in manually. When i fill out my form and submit the data it sends it out successfully ( i checked my database) but when i run a query the results do not change on the form dropdown control does not show the new results it just stays on default. i have 2007 infopath and a 2005 sql</p>