lodmark
Member
- Local time
- Today, 13:50
- Joined
- Jul 24, 2020
- Messages
- 232
Hi I'm back!
I have now fixed the errors I made on the form that @arnelgp helped me with.
Now it works and I have continued to add more vinyl records to the database.
As I told you before, the basis of this database is an Excel sheet with music in my disco radio programs on Halmstad's local radio.
The programs are in Swedish but feel free to listen on Thursday evenings at 20:00 at http://radiohalmstad.se
My question concerns the form where I want to add music to new programs but also fill the list with music in the programs I have already done.
My Excel sheet contains the music linked to the artist and the date the program was broadcast.
This is now entered into different tables, tbl_artist, tbl_music, tbl_program, tbl_program_date and tbl_program_music where the last table connects the programs with the music because a song can appear in several programs.
The form is called frm_program and I have entered the songs for the first five programs by hand.
Now I want to be able to select program six in the form and then start adding the songs.
This is not possible. In the subform to frm_program where the songs appear, I have tried to add two combo boxes, one for the artist and the other for the music.
The idea is that it should only be these two when everything works.
When you have selected the artist in one combo box, only that artist's songs should be possible to select in the combo box for the music.
As always, I appeal to you for help with the code for this.
Is there anyone who is interested?
Leif
I have now fixed the errors I made on the form that @arnelgp helped me with.
Now it works and I have continued to add more vinyl records to the database.
As I told you before, the basis of this database is an Excel sheet with music in my disco radio programs on Halmstad's local radio.
The programs are in Swedish but feel free to listen on Thursday evenings at 20:00 at http://radiohalmstad.se
My question concerns the form where I want to add music to new programs but also fill the list with music in the programs I have already done.
My Excel sheet contains the music linked to the artist and the date the program was broadcast.
This is now entered into different tables, tbl_artist, tbl_music, tbl_program, tbl_program_date and tbl_program_music where the last table connects the programs with the music because a song can appear in several programs.
The form is called frm_program and I have entered the songs for the first five programs by hand.
Now I want to be able to select program six in the form and then start adding the songs.
This is not possible. In the subform to frm_program where the songs appear, I have tried to add two combo boxes, one for the artist and the other for the music.
The idea is that it should only be these two when everything works.
When you have selected the artist in one combo box, only that artist's songs should be possible to select in the combo box for the music.
As always, I appeal to you for help with the code for this.
Is there anyone who is interested?
Leif