Hello -
I have a form that allows users to enter a song's:
Here's what I'd like to do: I would like to add a subform (maybe a different control would work better) to "store" each selection (Song title) but here's the catch....in order.
In other words, as the user selects the song they would like to print the subform/control would keep tally in the following way in that subform/control:
1- Song 1
2- Song 2
3- Song 3
...And so on. This control would not only serve as a visual queue for the user of the songs they have selected thus far but I would REALLY like for the songs to be printed in the shown 1, 2, 3, order.
I have tried building a new query, formulas, looking in the report's properties, etc. Maybe I've been at it for so long I have missed the really simple solution. Any help is much, much appreciated.
Thank you!
I have a form that allows users to enter a song's:
- Title
- lyrics
- And has a Yes/No field (PrintSong) which selects the song to be printed
Here's what I'd like to do: I would like to add a subform (maybe a different control would work better) to "store" each selection (Song title) but here's the catch....in order.
In other words, as the user selects the song they would like to print the subform/control would keep tally in the following way in that subform/control:
1- Song 1
2- Song 2
3- Song 3
...And so on. This control would not only serve as a visual queue for the user of the songs they have selected thus far but I would REALLY like for the songs to be printed in the shown 1, 2, 3, order.
I have tried building a new query, formulas, looking in the report's properties, etc. Maybe I've been at it for so long I have missed the really simple solution. Any help is much, much appreciated.
Thank you!