Results 1 to 3 of 3
  1. #1
    lithium is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2013
    Posts
    72

    Look up .key


    I am using a treeview that I have populating four total nodes deep. I want to be able to display related data if the user clicks the very last child node (basically show which parent is that nodes parent all the way up the tree). How would I be able to look up the data that was assigned to the .key function? Essentially each top parent node starts with a1, then goes to a2 for the next parent, and the child to a1 is b1 and it keeps going (to c1 being b1's child)...if they click c1, I want to look up the information in the table that is at b1.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Maybe with DLookup() domain aggregate expression?

    I've never used treeview. There is a click event? It will pick up the value from the node?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  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,849
    I don't know the answer to your question.
    See this recent post that was answered by theSmileyCoder who is very knowledgeable of treeviews.
    (He also has a series of videos on Youtube specific to treeviews.)
    The post and/or the included database may give you some ideas.
    Good luck.

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

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