Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: Validation Poblem

Discussion in 'Information Technology' started by Ofer Cohen, Jul 28, 2006.

  1. Ofer Cohen

    Ofer Cohen
    Expand Collapse

    If you are talking about a form, a validation before the data is inserted to
    the table, then on the before update event of the form you can run the code

    If (Nz(Me.OAP,0) + Nz(Me.Child ,0) + Nz(Me.Adult,0)) > 4 Then
    MsgBox "All fields can't be greater then 4"
    Cancel = True ' Wont let the user save the record
    End if

    Good Luck

    "Damo447" wrote:

    > 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.
    > Do you know a validation method which would agree with these requirements?
    > Please help!
  2. Loading...

    Similar Threads Forum Date
    Has This Story Any Validation In Sikhism ? Sikh Sikhi Sikhism Sep 3, 2004

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page