automatically entered

J

Jane

Is there a way to enter information in one form and have some of the same
information automatically be entered into another form? How would I do this?
I have both tables and form made but don't know how to have the information
automatically enter on the other form. any help would be greatly appreicated.
Thanks in advance.
 
J

John W. Vinson

Is there a way to enter information in one form and have some of the same
information automatically be entered into another form? How would I do this?
I have both tables and form made but don't know how to have the information
automatically enter on the other form. any help would be greatly appreicated.
Thanks in advance.
Click to expand...

Data is not stored in Forms. It's stored in Tables; a Form is just a
window onto the data in your tables. If you second form uses the same
table as the first form, then entering data (via either form) will
make it visible in the other.

It sounds like you may be trying to store the same information
redundantly in two different tables. If so... don't! What are the
tables involved? What information are you trying to store, and why
does it need to be shown on two forms?

John W. Vinson [MVP]
 
J

Jane

John,
I have two tables. One is for our product. Ex. Product #, Description,
Date sold, and other information on it. The second table is a log which has
the product #, date issued, date completed, and description. My boss would
like the product #, Date issued and the description to automatically fill in.
Can I do this? Thanks Jane
 
J

John W. Vinson

John,
I have two tables. One is for our product. Ex. Product #, Description,
Date sold, and other information on it. The second table is a log which has
the product #, date issued, date completed, and description. My boss would
like the product #, Date issued and the description to automatically fill in.
Can I do this? Thanks Jane
Click to expand...

You can. But - It would be A VERY BAD IDEA.

Storing such information redundantly wastes space - no big deal - but
much worse, it risks data inconsistancy. Suppose you have a product
with a description; and a log file which ALSO contains a description.
Either description could be edited at any time; then you would have
*two different incompatible descriptions*, and no way to tell which is
right!

Instead, use a Form based on the Product table showing the information
pertinent to that product (including the description); and a Subform
based on the log table, using the Product # as the master/child link
field. That way you can see the product information AND the log
information at the same time.

For Reports, use a Query joining the two tables. It will have all the
fields from both tables available; you don't need to or want to copy
anything other than the Product# into the log table.

John W. Vinson [MVP]
 
J

John W. Vinson

John,

That sound like a better idea. How would I do that? Thanks again.
Jane
Click to expand...

"that" being the Form?

Use the Form Wizard. Create a Form using the two tables. Choose the
Subform option.

Or "that" being the Query? Create a new Query. Add both tables. Join
them appropriately. Include whatever fields you want to see.

John W. Vinson [MVP]
 
Top