Results 1 to 3 of 3
  1. #1
    The is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    13

    Question extracting data for combo box

    Hey guys,

    I want to make a combo box form for a table. The table has unique id, also a category id. I want the drop box to bring a list of the category from the category table, and I want the value being submitting is the category id not the name.
    Thanks a lot

    Table1


    Cat_ID
    Cat_Name

    Table2
    ID
    Cat_ID
    Topic

  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,771
    Sounds like you want a multi-column combobox. Review http://www.datapigtechnologies.com/f...combobox3.html
    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
    The is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    13
    Thanks sir

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

Similar Threads

  1. Extracting data from reports
    By Dhivya in forum Reports
    Replies: 3
    Last Post: 07-04-2014, 08:50 AM
  2. extracting data from field
    By focosi in forum Queries
    Replies: 6
    Last Post: 02-11-2012, 03:12 AM
  3. Help! Extracting Data from table to Form.
    By iProRyan in forum Forms
    Replies: 3
    Last Post: 01-29-2012, 02:12 PM
  4. Extracting text from XML data
    By rob4465 in forum Access
    Replies: 1
    Last Post: 03-18-2010, 06:41 PM
  5. Extracting data after a keyword
    By KerryA in forum Queries
    Replies: 1
    Last Post: 02-11-2010, 09:56 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