Hymnals mine db

[mikevds]

I am attatching a hymnals mine db
I realize work has to be done.
The purpose is as described in the form cd or hymnal subform
is display Songs

1st combo Name of Song

2 combo hymal name
3 combo cd name
4 combo weather it's a cd or hymnal
Perhaps I have to figure out the cirteria so it filters out if it's hymnal or cd

I think the best way would be two seperate queries
One for CD and the other for Hymnal.

Eventually I want to be able to do other multiple searches as well Like Author, Name of Song, Hymnal or CD

It would be nice if this could be searched all different ways and levels in one form but it would be to much coding I think.

should this be seperate tables and queries into one form or just the queries or should I Split them?
I will email anyone the file so they can look at it for themselves

 

[John Big Booty]

Dude, this is the third almost identical thread you have started on this subject

One thread will do the trick, multiple threads will get you onto peoples ignore list in quick time. If you think you've missed something or wish to expand, try making additional posts to your first thread.

As far as your search goes check out this search tool