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/1353.aspxFri, 09 Jun 2006 10:55:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1353rasmus0https://www.infopathdev.com:443/forums/thread/1353.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1353I've created a form that queries in an access db table. The table contains several fields which needs to be queried, which is no problem. <br /><br />The problem occurs when/because the table contains 7 fields named "DAY1", "DAY2"...."DAY7". Thus, before the user of my form runs a query, he/she has to input a date. Hopefully the form will only show results where the date chosen by the person filling out the form matches one of the dates in my table fields "DAY1", "DAY2"...."DAY7". <br /><br />I've tried to use the custom code and rules function, whereby the form should only run a query, if there is a match between the day chosen, and one of the dates "DAY1", "DAY2"...."DAY7", but it doesn't work. I suspect the problem occurs because somehow the date chosen by the form user, affects the following query. Thus I've inserted a secondary dataconnection, to separate the query fields and the "chosen date" (secondary dataconnection), but it still doesn't work. <br /><br />If the above makes sense, is there an easier way, a form code or something else, which can solve my problem?