hymnal and song subform (1 Viewer)

[mikevds]

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.

The idea is to create another form with author, and it would display the songs from what hymnal the author wrote.

 

[boblarson]

What code or macro are you using for that click event? We might have to have you upload the database to be able to play with it to see what's up. I'm more visual anyway and can usually troubleshoot better that way.

 

[MSAccessRookie]

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.

The idea is to create another form with author, and it would display the songs from what hymnal the author wrote.

Is this an improvement on (or maybe the next generation of) the database referred to in the post below (the one that you were working on at the end of last year)?