I have created a custom music database.  I wish to create a way to query the database for a song name.  So far I have created a sql query for "Rudolph The Red Nosed Reindeer"

SELECT tblTitles.TitleID, tblMediaType.MediaTypes, tblTitles.Title, qrySongTitle.MediaTitle, tblTitles.TitleNumber, tblTitles.GroupPerformer, qrySongTitle.SongTitle, qrySongTitle.SideDiscNumber, qrySongTitle.SongPosition, qrySongTitle.SongType, qrySongTitle.SongLength, tblTitles.MediaType
FROM (tblMediaType INNER JOIN tblTitles ON tblMediaType.[MediaTypeID] = tblTitles.[MediaType]) INNER JOIN qrySongTitle ON tblTitles.[TitleID] = qrySongTitle.[MediaTitle]
WHERE (((qrySongTitle.SongTitle)="Rudolph The Red Nosed Reindeer"))
ORDER BY tblMediaType.MediaTypes;

I would like to create an action that will bring up a form to get the Song to search for, put that into a variable and plug that variable into the above SQL statement programmatically.  I have created a report that would then display the results of the query as seen in the attached file.

I have it working manually be typing in the Song to search for in the SQL statement, saving the SQL Query and then opening the report.