Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: Reset Drop Down on the basis of selection

    There are 5 drop down in my form:

    ddl1,ddl2,ddl3,ddl4,ddl5.

    ddl1 is mandatory to select rest of them user has to select only one other wise it gives error what i write on my button so that it check if user select values from more then 1 drop down ( in ddl2,3,4,5)it gives error message and reset again all the drop down to blank.

    Thanks,

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    For simplicity and speed, I would instaniate a local variable to keep track of how many ddl's have been selected:

    Dim intDdlCnt As Integer

    private sub ddlx After_Update()

    if intDdlCnt > 1 Then
    'reset stuff here
    Else
    intDdlCnt = intDdlCnt + 1
    end if
    end sub
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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