Form with an editable subform

[drums_4_life]

Okay, I have a database of Music. It consists of Music titles, tempo, Key signature, theme, Genre, and Author. The whole point of the database is to organize music set lists for up coming shows. So I would like to make a form that can search through set list dates and when the form goes to that set list date an editable subform shows me the songs in that set list. I would like to be able to add songs and remove songs to edit the set list. I'm not sure if this is enough information, if not let me know and I will try to explain more about it.

Thanks, all
Grant

 

[ted.martin]

So all you need is a method of selecting the SetList date and then filtering the Music list based on that selection.

One way would be to maintain all the Set Lists in a separate table, and perhaps show these with any descriptions in a continuous form. Maybe used the double-click event for the Set List date in that form to open the Music form, filtered by that date.

Just be careful if you use SQL to filter the date as the date needs to be in US format e.g. mm/dd/yy.

 

[drums_4_life]

Thanks for the help.
I have made a separate table for the set lists.
I'm a little rusty on the terms haha. like a continuous form or double-click event could you help with that?

Grant

 

[ted.martin]

A continuous form is a form where rather than showing just one record, it shows them all one beneath the other. It seems to me that as you are only wanting to use the Set Lists as a date search/select form, this would be helpful to enable you to see them all.

The next thing then is to select the Set List record you want and then use the date to open the main form and associated sub form.

Given you are rusty in this, then rather than trying to use some code to open the form and filter it, create a query for the F-Main form and in the Set List date field, put in the criteria Forms![F-Set List].tag

An event is what takes place when you (say) double-click on a text box control.

On the set list field which you would double-click to run to open F-Main, right-click the control and select Properties and then go to the Events tab. At the end of the Double-Click even line there is an ellipsis (3 dots ...). Click this and choose by Code - The code window opens and your should enter this code between the Private Sub Line and the End Sub.

me.tag = yourdatecontrolname.value
docmd.openform "F-Main"
docmd.close acform, "F-Set Lists"

Note I have suggested form names and control names, but use your own.

Tag is a useful way to transfer a value to a query without using filer code, which is of course the more professional way to do it.

There will be lots of alternative ways to do what you want but here I was trying to keep it simple.

Good luck.

 

[drums_4_life]

I made a continuous form of my set lists but when i use the form and go to the specific date that i want to add or remove songs i run into this problem.

I want to be able to click on the song title menu bar and pick a specific song and then have the form automatically fill in the tempo and key signature for that specific song. How can i make this happen? Thank for all the help.