automatically updating data from one form to another

[Access_Newbie]

need to know how to automatically updating data from one form to another. I
have my two forms and I have them set to pull up records with specific
information only but I can not figure out how to update in 1 form and have it
automatically update in the other so I do not have to.

Any help would be nice.

 

[Jeff Boyce]

Access forms display data, Access tables store it.

If you use one form to add/edit a record (in a table), any other form that
"looks" at that table should be able to see the changes.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Access_Newbie]

Ok maybe need to reword. I would like data entered from form one to
automatically be enter on form 2. How do I link that field to automatically
update once someone enters data on the form 2.

Thanks

 

[John W. Vinson/MVP]

Ok maybe need to reword. I would like data entered from form one to
automatically be enter on form 2. How do I link that field to automatically
update once someone enters data on the form 2.

Reread the message.

You cannot update the data in a Form because *the form does not
contain any data*, any more than my office window "contains" the
Owyhee Mountains.

If you have two forms based on two different tables, and you want the
data in the second table to change when you change the data in the
first table, *your database design is incorrect*. Information should
be stored only once; you can then use two different forms to give you
two different ways of looking at the same stored data.

What Tables do you have in the database? What information do they
contain? What are the Recordsource properties of the two forms?

 

[Access_Newbie]

I have a main table (contains-- Project num, rev, name, author, Tech writer
who worked on it, due date, ship date, type of manual, status, PM, PE, EE,
Notes)

I have a Shipment table (contains Project num, rev, name, due date, ship
date, type of manual)

I have also made tables that contain authors, EE, PM, PE, tech writers, type
of manuals, status to choose from.

I also made a switchboard to direct them to which form they need.

I have no idea how to find record source properties.

muddled through as far as I have --cant write expressions, and not sure how
to set up reports.

Thanks

 

[John W. Vinson/MVP]

I have a main table (contains-- Project num, rev, name, author, Tech writer
who worked on it, due date, ship date, type of manual, status, PM, PE, EE,
Notes)

Well, clearly you know what PM, PE, and EE mean - but nobody here
does.

I have a Shipment table (contains Project num, rev, name, due date, ship
date, type of manual)

That's a problem right there. The Shipment table probably should not
contain a name field. A Project has a name; a shipment doesn't. The
same is probably true for the type of manual.

What is the Primary Key of each table? If it doesn't have one... it
needs one. How are the tables related in the Relationships window? If
they're not... they should be.

I have also made tables that contain authors, EE, PM, PE, tech writers, type
of manuals, status to choose from.

Same questions.

I also made a switchboard to direct them to which form they need.

Fine, but irrelevant to this discussion.

I have no idea how to find record source properties.

Open the Form in design view. View its Properties (right click the
little square at the upper left intersection of the rulers). Select
Properties. (There are other ways to see them but this is quick and
easy). Find the Data tab. The Record Source is the first line. What's
in it?

muddled through as far as I have --cant write expressions, and not sure how
to set up reports.

Nobody, you included, has said anything about expressions or reports
yet!

I'm GUESSING - based on the little you've posted - that you're trying
to use separate forms for each table. It's likely that you would do
better to have a Form for the Project table, with a Subform for the
Shipments table. Since I don't know the business logic (does a
Shipment apply to a Project, or a Manual, or multiple Manuals, or
what?) I'm not sure how the form and subform should be linked, but
it's *not* going to be necessary to "update data from one form to
another".

 

[Access_Newbie]

Well, clearly you know what PM, PE, and EE mean - but nobody here
does.

Means project Manager, Project Engineer, Electrical Engineer

That's a problem right there. The Shipment table probably should not
contain a name field. A Project has a name; a shipment doesn't. The
same is probably true for the type of manual.

The shipment is the manuals to site. Problem is if someone comes to me
without the project number and wants info one a specific project-- I can look
up with the project name.

The manual type consists of Operations and Maintenance, Submittal, and
Commissioning so I need to tell them apart since I might have 3 records for
each project number/name of project with different project numbers.

What is the Primary Key of each table? If it doesn't have one... it
needs one.

Primary Key Main Table-- I would like to set it for the project number and
revision but some of our records contain alpha not numerical and when I tried
to set the key it says --can not contain a null, please remove/fix--

Primary Key Shipment table-- Not defined yet-- can figure out how to --get the same error message--

Right now not defined until I get figured out.

How are the tables related in the Relationships window? If

they're not... they should be.

Relationships-- I have all the seperate tables going to the main table I
believe, not sure how to check-- I wen t in and licked edit-create new- made
main table the left and the shipment table the right and set on Project
number since each record has that, then I try to click the enforce
referentail integrity and it comes up with "no unique index found for the
reference reference field of the primary table"--so i just dont select
enforce and it says ok.

Am I setting this up backwards?

The Record Source is the first line. What's
in it?

It says "Main table" and "Shipment table"

I'm GUESSING - based on the little you've posted - that you're trying

to use separate forms for each table. It's likely that you would do
better to have a Form for the Project table, with a Subform for the
Shipments table. Since I don't know the business logic (does a
Shipment apply to a Project, or a Manual, or multiple Manuals, or
what?) I'm not sure how the form and subform should be linked, but
it's *not* going to be necessary to "update data from one form to
another".

--What is needed is a simple table/form for one group to input the shipment data into when the ship the manuals-- and a seperate table/form for the tech writer to input the manual data into. Is this possible?

Thank you for the help-- sorry if I am not clear enough in explinations.