Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    107

    Unanswered: design / validation question

    I have a master container form that is bound to table1. Then I have a few subforms that are also databound.
    My question / problem is this:
    On the master form, there are a few fields that need to be defined as "mandatory" but the values cannot be specified until the user has gone through and filled in all the subforms. If I make them mandatory, the system doesn't let me fill out any of the subforms until a value is provided.
    How do i get around this?
    Any suggestions?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    In your validation you must check the child forms first (order matters!)
    Once the child forms have passed validations (i.e. have records) you can begin to validate the master form.

    Make sense?
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Make the field mandatory via CODE, rather than the Required property. The code can take into account the missing data and only validate it if the necessary values are present in the subform.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •