Need help

R

Ron

I have a form(A) that pulls data from another form(B). Within form(A) I have
a report printed out. Periodically I have to change some information on
form(B). I would like to have the information on the reports already created
from form(A) to remain unchanged. If changes are made, I would like the
changes to only reflect future reports. Is there a way that this can be done?
 
J

John Vinson

I have a form(A) that pulls data from another form(B).
Click to expand...

Ummm... forms don't (usually) pull data from Forms. They pull data
from Tables. A Form is not suitable as a data repository; it's a
window onto data stored in a table, typically. You *can* use an
unbound Form as a temporary data storage location, but it would be
unusual to do so! How are you "pulling" the data?
Within form(A) I have a report printed out.
Click to expand...

Again, a Form cannot "contain" a Report. How are you printing it out?
Do you have a stored report that you're launching?
Periodically I have to change some information on
form(B). I would like to have the information on the reports already created
from form(A) to remain unchanged. If changes are made, I would like the
changes to only reflect future reports. Is there a way that this can be done?
Click to expand...

Only by basing the Report on a query selecting data from the table
being used as FormA's Recordsource.

It appears that you're focusing on Forms and Reports - again, THEY
CONTAIN NO DATA. The foundation of your house should be the Tables; if
you have data that you want to keep permanent, and other data which
should change, then you need two different tables for these two sets
of data! The Report can be based on either table, or on a query
linking the two, as needed; but you must have the data stored
*somewhere*.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
R

Ron

Ok I used the form as a reference. I do have tables within these tables i
created forms and reports. On one of the tables there is a field that is a
number and it is called Calibration Frequency. This number may change from
time to time. I created a report from information from several tables. I want
the information to remain as it was entered. If there is a change to the
frequency field, I want only the new information to change. The information
that was entered into the record to remain the same. Is there a way to do
this. Hope this will help.
 
J

John Vinson

Ok I used the form as a reference. I do have tables within these tables i
created forms and reports.
Click to expand...

Again... jargon alert!

You don't create forms or reports "within" tables. Tables store data;
that data gets combined, selected, sorted in Queries; you base Forms
or Reports on these queries (the query is called the form or report's
Record Source).
On one of the tables there is a field that is a
number and it is called Calibration Frequency. This number may change from
time to time. I created a report from information from several tables. I want
the information to remain as it was entered. If there is a change to the
frequency field, I want only the new information to change. The information
that was entered into the record to remain the same. Is there a way to do
this. Hope this will help.
Click to expand...

You'll need to store the Calibration Frequency in *TWO* tables: one
table for the current default value, and the other for the actual
stored data. The Reports will be based on this second table.

Since I don't clearly understand how your tables are structured or how
you're actually using this calibration frequency I can't be more
specific.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top