personal library

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top