Book library form list boxes

[mikevds]

I have the following fields

This works...

Table: Author
ID_Author - AutoNumber, Primary Key
AuthorName - Text, (length 50)

Table: Book
ID_Book - AutoNumber, Primary Key
link_Author - Number (Long Integer)
BookTitle - Text, (length 50)

-----------

Form: Test Form

two controls -

ListBox #1
Properties...
Name: list_Author
Row Source Type: Table/Query
Row Source: SELECT Author.ID_Author,
Author.AuthorName
FROM Author
ORDER BY [AuthorName];
Column Count: 2
Column Heads: No
Column Widths: 0";1"
Bound Column: 1

On Click Event - Event Procedure

Private Sub list_Author_Click()
Me.list_Title.Requery
End Sub

-----

Listbox #2
Properties...
Name: list_Title
Row Source Type: Table/Query
Row Source: SELECT Book.ID_Book,
Book.link_Author,
Book.BookTitle
FROM Book
WHERE (((Book.link_Author)
=NZ(Forms![Test Form]!list_Author)))
ORDER BY Book.BookTitle;
Column Count: 3
Column Heads: No
Column Widths: 0";0";1.5
Bound Column: 1

Publisher
Publisher ID
Publisher Name

Age Group
Age Group ID
Age Group Name

I have all the coding done for Author and Title, It's not populating
However, in one form I want to be able to have three drop downs
Form 1
Title,
Author (only diplays by those Titles
Publisher
_____________________
Form 2
Or Publisher first list box
Author 2 list box
Pub name 3rd list box
I will attatch a sample file