Results 1 to 3 of 3
  1. #1
    cantord is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    15

    combo box help

    I have a combo box with values aa, ah, ai and more..How do i reference the selection?

    Code:
    me.comboname.value= "aa"
    does not work for me

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Code:
    me.comboname.value= "aa"

    Does not reference the selection, it sets the selection to aa!

    To reference it would be

    Code:
    Whatever = Me.comboname.Value

    or, because Value is the Default Property of a Combobox, simply

    Code:
    Whatever = Me.comboname


    If you're asking how to determine if the selection is 'aa' you could use


    Code:
    If Me.comboname.value= "aa" Then


    Linq ;0)>

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

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

Similar Threads

  1. Replies: 1
    Last Post: 10-30-2012, 10:29 AM
  2. Replies: 2
    Last Post: 08-16-2012, 10:02 PM
  3. Replies: 1
    Last Post: 07-11-2012, 08:36 AM
  4. Replies: 5
    Last Post: 03-12-2012, 02:58 AM
  5. Replies: 4
    Last Post: 08-16-2011, 05:54 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