Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2013

    Exclamation Unanswered: Creating mandatory field in a form once another field is updated

    Hoping someone can help!

    I have a form that has a field called status after inspection which is linked to a table which has approx. 20 status's:

    I need when 20 of those status if one is selected into my form for the fields diameter & height to become mandatory fields (both these fields are dropdown) and if any of the other status's are chosen to have diameter, height and complete (date) field mandatory.

    Can this be done?

    Only one status can be entered per job but if it changes the mandatory additional fields need to activate.

    Hope that makes sence.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    should be easy enough to implement

    is it just the one status that requires the diameter and height, or is it several.

    for me Id add a column to the status table that indicted if these values were required
    then when those statuses were chose Id take appropriate action. id probable hide or disable the controls if not required, and show/enable if rrequired

    in the forms before update event I'd test to see if the controls were enabled or visible and if so then validate the data.
    you'd also need to pace your visible/enable property in the forms on current event
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2013
    I'll give that a go and let you know thank you for your help.

  4. #4
    Join Date
    Nov 2013
    There are over 10 which require diameter and height and approx 7 that require diameter height and complete date.
    Is there some sort of code for this thing rather than hide?

    Sorry I'm fairly new with acces.

Tags for this Thread

Posting Permissions

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