Query (Filtering?) in a Form

[bobhra]

Hello,
I am beginner in Access and besides that 2007 design makes no sense at all.

Situation:
I have 2 tables

Courses
--------
CourseID - primary, text
Capacity - number
Tutor - text

Books
--------
ISBN - primary, text
Title - text
Author - text
CourseID - text, foreign key

Scenario: The DB represents each course that has its own recommended books.
I created One-to-Many relationship between Courses and Books tables as there may be several books recommended for one course and only one course for each book.

Then I faced a problem - I need to design a form for querying recommended book information for any course that the user choices. Only the CourseID must be provided by the user, and course tutor, book title and author must be displayed. I need to use sub-forms as there will be many books recommended for one course, so all relevant information (and there may be really loads of rows) must be displayed in a grid sub-form.
And I spent 2 days in a row trying to do it. It involved creating buttons and assigning filtering actions to them, playing around with object properties and so on. Nothing helped. I am pretty sure it can be achieved without using VB code as this task is really basic.

To make everything more clear I attached the draft DB. Hope this helps. It has a form with a button to filter the form (near courseID field). Sub-form information updates, but not the Tutor field.

Thank you in advance

[ajetrumpet]

http://www.access-programmers.co.uk/...d.php?t=203589

[bobhra]

Thank you for the response.
I did post it on several forums as this is a bit urgent, so having answers from many experts would be very helpful
Besides that I figured out that this is not a very good example, as in this one it requires many-to-many relationship.
Thanks for pointing to that forum, I updated the attachment and description.