Solved

Jumping down to validated field

Posted on 2009-04-06
2
194 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Accepted Solution

by:
Bill-Hanson earned 500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to add a username for multiple users in Lotus 6 127
VBA Lotus notes 2 211
Updating Lotus Notes workspace icons with new server 1 150
Lotus Domino server 9 7 91
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 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