Hi Guys,
I have been asked to design an access database/project and I have a specific coding problem.

I have a drop down control which is populated with a list of authors from the authors table (tblAuthors). When I select (click event) on a author in this drop down list I want to display all the Titles, Publisher, ISBN from the appropriate tables that this author has stored in the database, it could be 1 or 15 and I want to store this info in tablular form.

Any direction to specific code examples appreciated

Kind regards
Andrew