Results 1 to 4 of 4
  1. #1
    Asma is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    11

    Unhappy Return the value of Multiselection dropdown list (VB)

    Hi

    I have a drop down list that has "other" as a choice and I have a text field called "if other, plz specify" next to it which is invisible.

    I want to check if "other" is one of the items selected from the drop down list is "other".
    when I'm using single selection drop down list the following code works:



    Private Sub dropdownlist_AfterUpdate()
    If (Me.dropdownlist = "Other") Then
    Me.If_other__please_specify.Visible = true
    Else
    Me.If_other__please_specify.Visible = false
    End If
    End Sub

    how to write the same condition ,but for multiselection drop down list ??

    plzzzzzzzz help

  2. #2
    Join Date
    Aug 2010
    Posts
    10
    It is not Me.dropdownlist.Value = "Other" Then?

  3. #3
    Asma is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    11

    Solved :D

    Its if (dropdownlist.selected(indexofselection) = true) Then...

  4. #4
    Join Date
    Aug 2010
    Posts
    10
    Good you figured out by yourself. What I sent if for List Box only.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Set up a dropdown List
    By asherbear in forum Access
    Replies: 2
    Last Post: 06-24-2010, 06:45 AM
  2. Dropdown Input Box?
    By Acilladon in forum Programming
    Replies: 3
    Last Post: 06-09-2010, 07:39 AM
  3. Dropdown list in a query
    By asherbear in forum Queries
    Replies: 6
    Last Post: 05-31-2010, 06:38 PM
  4. Replies: 1
    Last Post: 05-17-2010, 12:21 PM
  5. Dropdown - need help please
    By sullyman in forum Access
    Replies: 8
    Last Post: 10-26-2009, 07:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums