Data populated from other form does not save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to ensure that data from one table is populated in another table.
Perhaps naively, when I originally made the form I used:

=Forms![Actual Emissions]![Permit Number]

to pull the information from the other form. When I close the form after
adding data to other fields the data is not saved in the table. I understand
it is just pulling the data from another form and that is why the data is not
being saved - but is there a way to get the database to save the data in my
corresponding field?

Thanks for any help - unfortunately I have never used SQL besides for
rudimentary exercises in Access so if there is a way to do this without
writing a lot of code - that would be great.

Thanks again,

Stephanie
 
I am trying to ensure that data from one table is populated in another table.
Perhaps naively, when I originally made the form I used:

=Forms![Actual Emissions]![Permit Number]

to pull the information from the other form. When I close the form after
adding data to other fields the data is not saved in the table. I understand
it is just pulling the data from another form and that is why the data is not
being saved - but is there a way to get the database to save the data in my
corresponding field?
Click to expand...

What are these two forms, and how are they related? Might it be possible to
make this form a Subform of the other, and use Permit Number as the
master/child link field? Or might the Permit Number actually be redundant, and
not need to be stored at all?

John W. Vinson [MVP]
 
there are several other field information is being pulled from as well and
the information is duplicative for all of it - which is why i'm trying to
pull it. however, the information is for two different tables and has to be
stored in them separately because it is for two different programs within our
department. eventually we are moving to an SQL server system and the
databases will be normalized at that time but currently, this is the way that
we have to do it so if there is anyway to pull the information from one table
and store it in another via forms, i would like to do that. i know it may
not be the most efficient method but is it possible?

thanks!

John W. Vinson said:
I am trying to ensure that data from one table is populated in another table.
Perhaps naively, when I originally made the form I used:

=Forms![Actual Emissions]![Permit Number]

to pull the information from the other form. When I close the form after
adding data to other fields the data is not saved in the table. I understand
it is just pulling the data from another form and that is why the data is not
being saved - but is there a way to get the database to save the data in my
corresponding field?
Click to expand...

What are these two forms, and how are they related? Might it be possible to
make this form a Subform of the other, and use Permit Number as the
master/child link field? Or might the Permit Number actually be redundant, and
not need to be stored at all?

John W. Vinson [MVP]
Click to expand...
 
Back
Top