to automatically retrieve data on table when code # is entered

[Guest]

I am working in Access. What I would like to do is enter in a vehicle unit
number, then its make, model, and VIN number automatically load into the
required fields. Can this be done?

 

[John Vinson]

On Sun, 27 Aug 2006 18:34:02 -0700, Natalie in Iowa <Natalie in

I am working in Access. What I would like to do is enter in a vehicle unit
number, then its make, model, and VIN number automatically load into the
required fields. Can this be done?

Easily... if you do it on a Form.

You should not be working directly in table datasheets in any case;
tables are designed to store data, not edit or display it. And you
should CERTAINLY not be copying this information redundantly from the
Vehicles table into any other table - just store the link to the
Primary Key (unit number perhaps??) of the vehicle table, and use
Queries to display information from both tables.

John W. Vinson[MVP]