Basic Validation problem

D

Damo447

I have created a ticket system.

In one table I have the fields OAP, Child and Adult.

No field is allowed to have a greater value (but can be equal) than 4 and
collectivly they must be equal or less than four.

I've tried a few validation methods but none have worked.

Please help!
 
R

Ron2006

My guess is that you will need to code those tests in the form where
you update them (because of the relationship between the TWO fields)

The same test would be executed in the before update of both fields on
the input form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation poblem 2
Validation: Basic Problem from a new user 4
Date Validation 1
Countif, IF condition is met 2
How to do - B2 is only valid if B1 is zero 1
Nested Iif Formula Question 3
Multiple condition data validation 3
Dsum with multiple Criteria not working 0

Top