MS Access 2007 - Linking subform with multiple queries

I have a table of song attributes, a table with Event details, and between them is a table that links several Song ID's to an Event ID with other fields that are specific to the event (like song order)

For flexibility, I always have a query between a table and its form so I can change what I want to see.

I want to be able to create a form that shows the song attributes at the top, then a subform that has the date of each of the events the song has been performed, along with other event-level data. I don't know why this is so hard for me to figure out - I've done plenty of forms and subforms before, but this one doesn't seem to be working. I created the proper relationships between the queries. Any suggestions?