I live in the Northern New Jersey area, and have done database developing. However I am working on a database for my music hymnals and songs. I have two tables one for music hymnals the other one for songs
Music Hymnal Hymnal Number ID Name of Hymnal Hymnal Song Hymnal Name which I think is extra Hymnal number page number author. The purpose is when a user clicks on the list box for song, it brings up the subform of what hymnal it is in related to that song. However I get a error message that the expression is typed incorrectly or coplex tobe evauliuated for example the expresasions might contain to many elements etc. What does this mean and how do I get around this? The relationships are sent to Hymnal Number ID and Hymnal Number I even read Mike Smart book access 2003 vba very simple tried flipping around the fields, I can't understand the error message/ I need some help, I hope someone can help me somewhow someway. I would need a one on one class on this.
