auto fill a form

[summernight]

please help I have tried but cant seem to get this to work. What I need is
information from form 1 to be auto field in on form 2 I already have a combo
box on form 2 that pulls data from a field (unit number) on form 1. Now I
need the information for 4 more fields (vin mumber,make,model,year) on form 2
that is also on form 1. Thank you.....

 

[Jeff Boyce]

I may be reading too much into your description...

It sounds like you want to replicate data. That is, you want data in one
table (visible via form1) to be added to a second table (via form2). If
this is what you are trying to accomplish, consider stepping back for a
moment.

You'd probably end up doing something (you haven't described) this way if
you were using a spreadsheet. Access is a relational database, though, and
requires a different approach if you are to gain the benefit of Access'
relationally-oriented features and functions.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[summernight]

Thats sorta what i'm tring to do. I also would like to use the combo box to
choose the unit number for in information that I wont to replicate.

 

[John W. Vinson]

please help I have tried but cant seem to get this to work. What I need is
information from form 1 to be auto field in on form 2 I already have a combo
box on form 2 that pulls data from a field (unit number) on form 1. Now I
need the information for 4 more fields (vin mumber,make,model,year) on form 2
that is also on form 1. Thank you.....

The point Jeff is making is - that's not how relational databases are supposed
to work.

They use the "Grandmother's Pantry Principle" - "a place - ONE place! - for
everything, everything in its place". Your vehicle information - make, model,
year - should be stored in the Vehicles table, probably with the VIN as its
primary key; it should exist NOWHERE ELSE in your database.

Remember that a Form does not contain any data. It's just a window. It
displays data stored in a form; if you want to just *see* the make, model,
color etc. from the vehicles table, then you can display it by including these
fields in the combo's row source query, and putting textboxes on the form with
control sources like

=comboboxname.Column(n)

where n is the zero based index of the field you want to see. But the *ONLY*
field that you copy into any other table should be the VIN, or the primary key
of the vehicle table, and store it into a same-datatype foreign key field in
your second table.

John W. Vinson [MVP]