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
    Guest

    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
    BS"D


    "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

Share This Page