+ Reply to Thread
Results 1 to 4 of 4

Combobox from one form filters another combobox in another form

  1. #1
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Question Combobox from one form filters another combobox in another form

    Hi guys,

    Need a lil bit of help here. I have two comboboxes each is placed in different form. I have frmlogin with cbousername, this combobox shows list of names located in sheet(login).

    Please Login or Register  to view this content.
    While frmcoaching has the cboagent. What Im trying to do is if for example I chose Bryan from cbousername, when frmcoaching loads cboagent will show list of names under Bryan. I tried this code but it is not working.

    Please Login or Register  to view this content.
    Hope somebody can help me out.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Combobox from one form filters another combobox in another form

    The following code works as you describe.

    Please Login or Register  to view this content.
    try changing this line

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    03-16-2015
    Location
    Philippines
    MS-Off Ver
    2007
    Posts
    13

    Re: Combobox from one form filters another combobox in another form

    Thank you for the help mehmetcik.. i tried the code that you have given me and it worked... the only problem that im encountering now is the listview. based on the code that you have shared, bryan has his own list of people under him. For example is choose bryan, cboagent is now showing the list of name. how will I filter the lsitview (ListView1) that when I choose a name Listview will only show the information just for the said name.

    Here is the code is have for the Listview::

    Please Login or Register  to view this content.
    I hope you can again help me out.

    Thank you so much

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Combobox from one form filters another combobox in another form

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-07-2014, 01:21 PM
  2. Userform Combobox to populate form: Can I change the order of the columns in the combobox?
    By CraigWiggins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2014, 12:14 PM
  3. [VBA] Userform Combobox filters prices in a form of price range
    By dylanrose in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2014, 11:41 PM
  4. update a Combobox in a Subform from a Combobox in the parent Form
    By danieldowds in forum Access Tables & Databases
    Replies: 2
    Last Post: 04-25-2014, 10:27 AM
  5. transferring combobox value from one user form to populate combobox on another
    By smartphreak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1