Union Query

[mikevds]

How can I create a Union Query on a form two populate two list boxes

Name of Song only displays songs related to that Hymnal

or

Name of Hymnal= every song in that Hymnal
SELECT HymnalSonginfo.[ID Hymnal], HymnalSonginfo.[Name of Song] FROM HymnalSonginfo ORDER BY [Name of Song];

I hope this coding helps.

Thanks,

Michael Van Der Stad

 

[John Big Booty]

What you are looking for is very similar to cascading combo box.

There are some examples here or do a search in this forum as the topic comes up on a regular basis.