Clicking on row in listbox populates another listbox with relevant data

I have a userform for a music collection that is named "frmRecordings". It has two listboxes on it. Listbox1 ("lstRecordings") populates with all recordings that are on my spreadsheet. When one of those recordings is selected I want listbox2 ("lstTracks") to show the tracks that are on that specific recording. The Tracks are on a separate Sheet in my workbook. And the Tracks sheet has all tracks for all recordings in my collection with a column labled "RecordingID" that can be used to pull up the tracks for that specific recording (I just don't know how). I imagine this is a simple program, but I'm too new to VBA to know how to do it, and I can't find a sample anywhere on the web.
Here is my code so far for the frmRecording (minus commandbuttons, etc):

Please Login or Register  to view this content.

I have also attached the excel workbook.
Can anyone show me how to filter the tracks for one recording and send that info to lstTracks?

Here are the columns of my Tracks sheet: ID | TRACK No | TITLE | COMPOSER | COMPOSER2 | COMPOSER3 | PLAY TIME | RECORDINGID
Each track has it's own ID, and the RECORDINGID is the ID assigned to each recording .
Let me know what additional info you need.
Thanks.

Just to give you an idea of what it might look like.

Administrative Note:

Welcome to the forum.

Is your forum profile up-to-date and showing ONLY the oldest Excel PRODUCT that you need this to work for? Not Windows, please.

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The four most recent Excel products are Excel 2019, Excel 2021, Excel 2024 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

Did you see post #5? Please update your forum profile as requested. Thanks.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
For new members: you will not be able to post a full URL, so remove the https://www. section and add one or two breaks to the rest of the address. A Moderator or Admin will then fix the link for you.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...stbox.1273107/)

How to update your forum profile:

Attach the workbook with the userform in it.

See attachment

Here you go.

Have to go out for a while but will look at it later today.

Took a bit longer then expected ut here it is. Think I covered it all so test and let me know.
Also fixed the automatic Track number. This will show up after you filled in the RecordingID in the Add Track userform.
In the Track listbox you can't have Columnheads because this is a filtered range. You can simulate these by putting Labels above the Listbox and line them out with the columns in the ListBox.

bakerman2, I fixed the auto ID on both forms, but when I enter a New Track on the frmNewTrack form only the first one I enter creates a new Track No. After I hit SAVE on the frmNewTrack I am left with entering the next Track no manually.
The delete button on the frmTrack form still deletes the track above the one selected.

In my file I've disabled the Auto ID and replaced it with a formula in Column1 on both sheets.
Doing it that way it doesn't mess up consecutive counting when you delete a row.
Also I've tested the file I posted extensively on deleting rows on both Recording and Tracks sheet and didn't encounter any errors. The correct row is always deleted.

lstRecordings gets filled using RowSource witch refers to a range on a worksheet.
lstTracks is filled by filtering a range in memory. Therefore ColumnHeads doesn't work and I replaced it with the Labels above the ListBox

In frmNewTracks replace current code with this.

Please Login or Register  to view this content.