personal library

[Guest]

i am building a database for all the books in my library.

i have one master table Books

i want to use a form to keep a record of checking out a book. i want to use
a combo box to select the [title] of a book

display related fields from the books table. i'm not sure how to relate the
text boxes on the form to the combo box.

 

[Duane Hookom]

You can make sure your combo box's row source includes any fields from the
books table that you want to display on your form. For instance:
SELECT BookID, BookTitle, Author, Pages, Publisher
FROM tblBooks
ORDER BY BookTitle;
Then assuming your combo box name is cboBookID, you can use text boxes with
control sources like:
=cboBookID.Column(2) 'shows the author
=cboBookID.Column(4) 'shows the publisher