I have a form with songs from a hymnal, all I want to do is link that list box the songs and have the subform display or drill ONLY THE SONGS FROM THAT HYMNAL. The query is set to view all records the table is set to name of hymnal and songs
I can do this as list boxes, there is no point in doing to a subform is easier
songs in hymnal and cd april 20007 I would like to include a list box from hmnal or cd or both, how do I do this?
The query from the list box is songs in hymnal query only and the relationships are set to hymnal name and hymnal song info.
I also have another form the samething where I want to craate one list box from author and the other one from what songs in what hymnal.
I have coded the sql query and nothing populates.
Regards,
Mike Van Der Stad
I can email you the file if you want personally. I've spend days, and years doing this with NO success. This is very fusturating when I copy the form coding I get error messages. I wish their was a book out that could help you step by step with what I am doing specificly setting up only this database.
Regards,
Mike Van Der Stad
I can do this as list boxes, there is no point in doing to a subform is easier
songs in hymnal and cd april 20007 I would like to include a list box from hmnal or cd or both, how do I do this?
The query from the list box is songs in hymnal query only and the relationships are set to hymnal name and hymnal song info.
I also have another form the samething where I want to craate one list box from author and the other one from what songs in what hymnal.
I have coded the sql query and nothing populates.
Regards,
Mike Van Der Stad
I can email you the file if you want personally. I've spend days, and years doing this with NO success. This is very fusturating when I copy the form coding I get error messages. I wish their was a book out that could help you step by step with what I am doing specificly setting up only this database.
Regards,
Mike Van Der Stad
