I'm creating a database to house my music collection, some of which are live
bootleg recordings, that have muliple discs.

Is it possible to have control that will create a subform for each disc, to
keep track listings, after inputing the number of discs each show has?

As an example, if a show consited of 2 discs, after I entered that info into
a number of discs field, can a control create a track subform for each disc?

john s wrote:
> I'm creating a database to house my music collection, some of which are live
> bootleg recordings, that have muliple discs.
>
> Is it possible to have control that will create a subform for each disc, to
> keep track listings, after inputing the number of discs each show has?
>
> As an example, if a show consited of 2 discs, after I entered that info into
> a number of discs field, can a control create a track subform for each disc?

Wrong design.
Album--(1,M)---Disc--(1,M)---Song
You're missing the Disc table. (DiscID (PK1),AlbumID (PK2))

You would probably do this with Album as the source of the main form,
Disc as the source for the Disc subform in main, and then Song would be
a subsubform (subform of Disc).