Validate 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

 

[S.Y.M. Wong-A-Ton]

I'm not sure what you mean when you say "But i'm not getting ay option there
to validate.". There where?

If you want to perform actions when you click the button, you can create
your own "Query" button and add rules on it. To perform a query, in a rule,
choose the "Query using a data connection" action and select the main
connection for your form. Other rules can be added to the button as desired.

 

[Joseph]

Thanks a lot Wong. It was of great help for me.

I'm not sure what you mean when you say "But i'm not getting ay option there
to validate.". There where?

If you want to perform actions when you click the button, you can create
your own "Query" button and add rules on it. To perform a query, in a rule,
choose the "Query using a data connection" action and select the main
connection for your form. Other rules can be added to the button as desired.

 

[S.Y.M. Wong-A-Ton]

No worries. I'm glad the information helped you.