InfoPath Dev

Hi guys,
I'm using direct database connection to get data for my form. I have some 
dropdownlists to filter the data also. Now when i click the "Run query" 
button which gets generated as part of database connection, i want to 
validate the dropdownlists. But i'm not getting ay option there to validate.

I tried using conditional formatting which will disable the button till all 
rules are satisfied. But I don’t want to disable the button.Instead I want to 
do the validation on click of button and show an error message box if any 
errors.

Can someone help please. I need it very badly.
Thanks
Joseph

Hi Joseph. Welcome to the forum.

You want to check the drop down lists when the user clicks the button. I think the issue is the stock (default) button you receive with the form.

Typically you would just add some rules to the button.  Open the properties of the button and switch it from a query button to a rules button with the dropdown.  Then you can do all the checks and logic you want. At the end once all of the validation has occured add a rule to Query your main connection.

Another method is to add a field to your form which holds the validation status.  You mayneed this external field to store your validation progress. Then on your query rule you can use the confition flag = foo and then the Query would run.

Hope this helps.

If you are working on database solutions you may want to check out the Database Accelerator. Qdabra Database Accelerator Suite Version 2.1 - Developer

Thanks a lot Clay. That was of great help and i got it working