Copying data form to form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

unknown - 06 Mar 2008 18:32 GMT

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.

Reply to this Message

Steve Sanford - 09 Mar 2008 06:04 GMT

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.

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

HTH

Signature

Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

> 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.

Reply to this Message