InfoPath Dev

I'm sorry - I've read this and am having trouble understanding - my guess is that you want to combine two data sources for your drop down values - are both data sources in SQL? If so, use a view to combine them into one.

You'd use a concat and some formulas for getting the correct range values - what version of SQL are you on? If 2005 or later, you can use BETWEEN otherwise you'd need ClosedDate < ... and ClosedDate > .... Do the values in ClosedDate include time?

I am so glad I married up..lol  The code in the solution is C# but I was creating a VB project thus the errors. 

I need to modify the following statement to only return rows from a SQL database where the "closed date" has been within the past 12 months (moving target since the query could be run at anytime during the year).  What is the correct syntax to handle this?  concat("ModifySqlQuery /dsname=ByteproAGS /where=where ...

I created an 2010 Infopath list form and published it into Sharepoint 2010. When I open it I can edit all the fields; however, another person cannot view or edit the Person/Group Picker field (the rest of the fields work fine for her). The rules on this field are the same I have for the other fields, so this is not the problem. Do you ...

I attached the form... I appreciate the help!!!

There are about 20,000 customers. Time to call in the troops (my husband) to help me get this code to work then.

In the browser, you should be able to add the top and bottom bars. In the client, only the top bar will show. Want to attach one of your forms via the Options tab to see if there's a form issue? You could also use the Options tab to attach a screenshot of what you're experiencing. Thanks.

Yes same thing... I'm using InfoPath 2010 with SPS 2010 does that make a difference?

Sadly, I don't think there are any such options out of the box for your request, so if you found a blog post with sample custom code, that might be the only way to go. A lot can be accomplished via code, but it's not easy.  How long is your source list? Depending on how many customer numbers there are, perhaps a dropdown would be ...