HI Every one,
I have created a front end form which is having input text boxes.
If the data has not been entered in any of the text boxes it should throw up an error message when i enter the submit button.
Please help me out!
Gautham (BOB member since 2014-12-04)
Moderator note:
Please edit your topic and give it a meaningful subject. Thanks.
Marek Chladny 
(BOB member since 2003-11-27)
What does the “submit” button actually do? Does it fire off a connection? Does it open a WebI document? Are you using the dashboard to write back to the database?
This is going to be tricky. Xcelsius does not do these kinds of checks very gracefully. But it is possible.
The method I would start with is to create a cell with a formula something like:
=IF(,IF(,-1,1),0)
Then you can create a label with an error message, and set dynamic visibility to check this cell for a -1.
If the submit button is firing a connection, set the trigger of the connection to run when the value of this cell becomes 1.
Do note that there are several other steps involved. The best way to do the is to have the submit button just update a cell. But you then have to reset the value of that cell so that it can capture when the submit button is pressed again. You will also want to reset the value of that cell after the connection runs. It’s a complicated bit of coding, and an awful lot of the timing depends more on how Excel runs its calculations than anything you can really control.
Lugh (BOB member since 2009-07-16)
I’ve done exactly the same thing, but have placed an invisible toggle button over my Connection Refresh button.
So if my validation checks fail, the Toggle button:
cdavies 
(BOB member since 2005-01-28)