Is there a way you can enter data on one form and the information from some
fields will transfer to another form automatically? If you can how do you do
this. I'm new to access. Thanks in advance.
The first thing to realize is that *you do not enter data into forms*.
Huh? I hear you say. <g>
You enter data *into Tables* using Forms as a tool. Forms are JUST
WINDOWS - they do not contain any data, only Tables do. You can have
two Forms both viewing and editing data in the same Table if you wish.
Your table structure should be worked out carefully first, before you
start worrying about forms. One of the key principles is what I call
the "Grandmother's Pantry Principle" - "A place - ONE place! - for
everything, everything in its place". If you find yourself copying
data from one table to another, STOP - it's a bad idea and is not
necessary; you store the data once, and once only, and then use
Queries to link the data in two or more tables together.
If you'ld like to post a description of your table structures and the
data that you're trying to manage we should be able to help. You may
also want to check out the tutorials at
Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
especially the Database Design 101 links on Jeff's page.
John W. Vinson[MVP]
