Results 1 to 5 of 5
  1. #1
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43

    I want to create a link combo box

    I got a problem to link both combo box together.



    If i got a list of different brand of shoe

    For example:

    Shoe brand combo box

    Nike
    Adidas
    Reebok

    When i want to find Adidas shoe it will only show Adidas shoe Part number.

    How can i do it this way?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the query of combo2 (parts) uses combo1 (brand) in the sql

    select [part] from tParts where [brand] = forms!myForm!cboBrand

    but be sure to add this update code to the combo brand afterupdate

    Code:
    sub cboBrand_afterupdate
    cboParts.requery
    end sub

  3. #3
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43
    For the different brand must i create a table?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You could have a brand table,
    or a query could pull brand names from the inventory.

  5. #5
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Don't forget to update the number of columns in the combobox so that it shows all the columns from the row source.

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

Similar Threads

  1. check, create and link a table in BE?
    By Frits1969 in forum Access
    Replies: 1
    Last Post: 04-21-2016, 02:34 AM
  2. Replies: 2
    Last Post: 05-22-2013, 02:50 PM
  3. Replies: 1
    Last Post: 01-10-2013, 05:59 PM
  4. Create an RDP link button on my form
    By BDP in forum Access
    Replies: 1
    Last Post: 09-14-2010, 02:49 PM
  5. Create the link
    By accessman2 in forum Access
    Replies: 0
    Last Post: 03-13-2006, 01:16 AM

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