Combobox from one form filters another combobox in another form

[Arvin.Amaro]

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.

[mehmetcik]

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.

[Arvin.Amaro]

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

[mehmetcik]

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