database forms

[Guest]

Im new to access and I'm doing a project for school. Im designing a system
for the school library. I need to set up the form so that when i enter the
book title the barcode and the ISBN numbers are filled in automaticaly.
thanks.

 

[Rick B]

HEre is a post from earlier today that points out one way to grab several
fields from another table and use them in your form. This is a very common
practice and if you search the newsgroups you will find lots of examples.
Rick B

The attached let's the user pick a Customer from the list, then fills in
other fields with information about that customer (similar to what you are
trying to do).
------------------------------------------------
Hi, Dave.

Maybe the easiest way to implement this is to include the Customer Rate as a
column in a combo box for the Customer Number and use the Column property of
the combo box. Something like the following for the combo box' RowSource
property:

SELECT Customers.CustomerID, Customers.Name, Customers.CustomerRate FROM
Customers ORDER BY Customers.Name;

Then set the DefaultValue property of the form field that stores the Rate
to:

=Me!MyComboBox.Column(2)

Hope that helps.
Sprinks

 

[SteveW via AccessMonster.com]

Using the columns in the combo box is a good way of doing what you want but
you must remember that the columns start counting from 0, so the first
column is numbered 0, the second is numbered 1 and so on.