Copying data form to form

  • Thread starter Thread starter unknown
  • Start date Start date
U

unknown

I have a small access database that I have created. I have one table with
three forms. There is a few duplicate data fields on the forms but not all. I
have the main form set to open the other forms based on choosing a checkbox.
What I need to do is automatically copy certain information from the main
form to the other forms when they open. All of the data entered is stored on
the same table. Any help is greatly appreciated.
 
You CANNOT copy data from one form to another!!!

**Forms do not store data. Forms are how you look at (display) the data.

**Tables store data.

**A query is a "virtual" table. You can join tables together to make it
appear as one table and base a form on that query. To have the data displayed
in a sorted order, you *must* use a query. You can create a query with one
field or all fields - it depends you what you want to see in your form.
What I need to do is automatically copy certain information from the main
form to the other forms when they open. All of the data entered is stored on
the same table. Any help is greatly appreciated.
Click to expand...

Add the field to the form. If both form's recordsources are a single table,
the data is there.

HTH
 
Back
Top