Re: personal library

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
--
Duane Hookom
MS Access MVP


"samuel" <samuel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A23525EF-60D5-42F4-B51E-099BA65A0CB6@xxxxxxxxxxxxxxxx
>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.
>
>


.

Relevant Pages