Choose what data to be on report

[fkneg1]

Hi,
I have Access 2013 but am new to Access and am learning as I go along!
I am making a database of song lyrics so have made a table of the title of the songs with the lyrics for each verse as different fields. I want to be able to choose multiple songs by their title to then show the full lyrics on a report - how do I do this? Any help would be appreciated. Thanks!

 

[Mihail]

By using a subreport based on table Lyrics

 

[Mihail]

But, maybe, is better to upload your database.
Convert the DB in Access 2003 or 2007, ZIP it then upload.

Note: Only in ZIP format you will be able to upload the DB now (based on the number of your posts = 1).
By the way, WELCOME TO THE FORUM !

 

[fkneg1]

Here is my database - hopefully you'll be able to see what I want it to do. Currently the button on the choose songs form does nothing but I want it to create the report.

 

[Mihail]

This is the right setup for your database.
I've keep in the DB yours "old" tables and forms but you should remove all after you see the differences.

Let me know if there are some bugs because I don't try with real data.

Good luck !

 

[fkneg1]

Thanks - Your design was not doing quite what I wanted the database to do but I have used a mixture of yours and mine to solve the issue.