Recent content by lodmark

Sorry. The problem lies in the form frm_record2 where I insert new records. There the medium is entered into the main form and I want that value to be saved for each record in the subform in the table tbl_music. Leif

Why didn't I think of that?

Hello @arnelgp If I can understand the code correctly it's for updating the field for media for all the records in the table, and just for once. I want it to happen every time I add a new record with songs? Leif

Hi @bob fitz I do understand the problems with "having the data in several tables" but its not the same data. One is for the record and the other for the song, even if the song is on the record. I don't thing there's going to be any problems with this in my database. I've tried picking out the...

Hi, it's been a while now. I have a small problem with my database. I need to automatically fill in the media that a song has. I have a form where I fill in the name of the album and artist, etc. There I also fill in the record company, year of release and the media that the album has, it can...

Hi Now I have solved the problem with searching for my records based on the artist and managed to sort them correctly. Almost in any case. Of course I used cascading combo boxes as you suggested. I tried an alternative solution first but here I couldn't get the sorting correct. Thanks...

Cascading combo boxes would solve my problem. But as it works today when I only select the artists from the artist table and with a connection to record_ID sorted by release year, I get all the records that that artist has released and that I have in my collection one after the other when I...

Fix this by changing the order of the tables in design mode. But now the artists first record doesn't come first, so there still things to fix. Thanks for today.

Your code works @arnelgp. I've managed to fix the missing punctuation. But now I've only have the result from the first field in the combo box, the record_ID. This is despite the fact that the bound column is number two. When I change to one or three, it still doesn't change in the combo box...

Thanks @Pat Hartman I will look into that. But it's a bit to change then...hm.

I have a drop down combo at the top of my form for my vinyl records where I can list the artists. This has worked for a while, it was you people that helped med get it right. But I missed an artist that only apeared in a record with various artists. So i had to fix so that even those artist got...

YES!

Yes that would do it. But I need the Record_ID as a result in the combo box as it's the record of the artist that i'm looking for. And the release_date for the sorting of the records of that artist. But it could probably be done in some other way.

Hey! That was almost embarrassingly easy. Thanks. But when I try your SQL statement as a row source in my combo box, I get the following error message: The SQL statement I entered looks like below and it works as long as I'm in design mode. SELECT...