Gus

[Gus]

How can i show a list of book Titles by the same author other than in Datasheet view, when i search my database by entering authors name in a textbox controlled by a command button.

Cheers Gus.

[orange]

What is your table structure?
Form (author) with subform (book titles)

[Gus]

Table fields are Author, BookTitle,Borrowed By, Date Borrowed, Return Date and Lender. The form will consist of 1 TextBox and a command Button when i type in Authors Name in the TextBox i want all the books by that Author to show up in a form. How do i achieve that.

Cherrs Gus.

[orange]

Gus, Are you saying there is one table only?
There is a free data model about Books and Libraries here
http://www.databaseanswers.org/data_...ooks/index.htm
that may give you some options on tables.

[Gus]

I have looked at the link you sent it only shows table relationships.
i have text boxes, on a form to show data which i have structured from Queries, IIF Statements e,g Authors Name, Book Title, Date Borrowed Date Returned i want to code a command button to show all the books in my Database by the same Author there is only 1 table as i am trying to keep it quite simple at the moment.

[orange]

It may seem reasonable to "keep things simple by having only 1 table" BUT
that is not how relational database works.
You really need a table for each "thing/concept" (entity) you are dealing with.
In my view you are dealing with

Books, Authors and Loans

Also, forms are ways of view/presenting data from tables in ways meaningful to you or the user.
Queries (SELECT) are a means of extracting data from one or more tables for various purposes.

You may wish to read a little on database normalization and design.
Here is a site, and the first few topics are directly related to design and table structure.
http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck.