Results 1 to 3 of 3
  1. #1
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53

    Dependent combo box

    Hi


    I have created a two table Process and category where process contains process steps and category contains different category depending on process I want to create a combo box such that when I select process , categories related to process has to be drop down.
    I have 2 tables ProcessT(PID,Process name) and categoryT(CID,Pid,category name) after using below process its showing blank in category field in combo box



    After executing the
    SELECT TblCategory.Category, TblCategory.ProcessID
    FROM TblCategory
    WHERE (((TblCategory.ProcessID)=[Forms]![FormTest]![cmbProcess]));

    query it is showing blank bcz of this my combo box is not working as desired


    plz help!!
    Attached Thumbnails Attached Thumbnails Unbenannt.png  

  2. #2
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53
    THE picture is jus for reference its not the one I have used

  3. #3
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53
    Images show
    before executing
    [Forms]![FormTest]![cmbProcess]
    And after
    Attached Thumbnails Attached Thumbnails tect1.png   tect2.png  

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

Similar Threads

  1. Replies: 1
    Last Post: 04-05-2016, 09:25 AM
  2. Dependent combo box in Web Database
    By Office10 in forum Access
    Replies: 9
    Last Post: 03-29-2014, 02:58 PM
  3. Dependent Combo Box Problem
    By JoshLewis in forum Forms
    Replies: 5
    Last Post: 04-04-2013, 01:19 AM
  4. Dependent Combo Box
    By tigers in forum Forms
    Replies: 1
    Last Post: 06-16-2009, 12:46 PM
  5. Replies: 3
    Last Post: 02-26-2009, 10:17 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