Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Jumping down to validated field

Posted on 2009-04-06
2
Medium Priority
?
200 Views
Last Modified: 2013-12-18
Have a form we use for ordering hardware. The main body of the form is setup in a 2 column table. On the most recent version we added a Yes/No question that they are required to respond to in order to proceed. Nothing out of the ordinary here.

What I am having an issue with is when I test the form, I enter a name in the first row, when I tab to move to the second field I get prompted with the validation ressponse. Strange thing is this validated field is 6 rows into the table yet it is going right there. I get the Notes error - did not apss validation after the validation response below.

I have tried numbering the tab sequence, but it is still going right to this question when I tab out of field 1. I have confirmed it is in the Input Validation section for this field, but cannot figure out why it is jumping right there out of sequence.

Any ideas?
@If(terms_signoff = "" ; @Failure ("You must respond to the question regarding the signature page and acceptance.") ; @Success)

Open in new window

0
Comment
Question by:jforget1
2 Comments
 
LVL 22

Accepted Solution

by:
Bill-Hanson earned 2000 total points
ID: 24079975
It would be very hard to say why the validation formula is firing out of order without seeing the form in the designer.  Validation formulas usually execute from the top to the bottom of the form.

On another topic, are you sure that you want the validation formulas executing every time the form is refreshed?  I normally only allow mine to run when the document is being saved.  If you want to check your fields only when the form is being saved, use the @IsDocBeingSaved function...

    @If(
      !@IsDocBeingSaved; @Success;
        terms_signoff = "" ; @Failure ("You must respond to the question regarding the signature page and acceptance.");
        @Success);
0
 

Author Closing Comment

by:jforget1
ID: 31567150
Did not know of that method of validation. That will be very helpful.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question