Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    UK
    Posts
    15

    Unanswered: Active Drop Down Boxes on a Form

    Hi

    I have a form with a Manufacturer Drop down Box, Type Drop Down Box, Model Drop Down Box and Software Drop Down Box. What I need to do is if ‘software’ is selected from the Type Drop Down Box the Software Drop Down Box is active and the Model Drop down Box is greyed out.

    If anything else in the Type Drop Down Box is selected the Model Drop Down Box is active and the Software Drop Down Box is greyed out.

    Is this possible?

    Thanks for your help

    Steve

  2. #2
    Join Date
    Jul 2003
    Location
    Kaukapakapa, NZ
    Posts
    15
    Hi Steve,

    Try the following After Update Event on the Type drop down.

    if me![Type] = "Software" then me![Model].Visible = False else me![Model].Visible = True

    if me![Type] = "Software" then me![Software].Visible = True else me![Software].Visible = False


    Dale

  3. #3
    Join Date
    Jun 2003
    Location
    UK
    Posts
    15

    Talking

    Thanks Dale,

    That worked perfectly

    Thanks again

    Steve

Posting Permissions

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