Validation on button_Click with direct database connection

[Joseph]

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

 

[Greg Collins]

You will need to write code to do this. The code would check all the
validation and then either report any errors or submit.

 

[Joseph]

Thanks a lot Greg. Got it working.

 

[Greg Collins]

Great! Glad to hear it!