I want a field from one form to show the same data on another form

[jo]

When I enter a date on my first form I want it to show on the next page where
I would add other values to other fields. But at the moment it only shows
todays date and if I change the condition on the 2nd form all the past
records will have the same date???
The field is called DateOfLastCal. At the moment it shows todays date but if
I changed it to the following all the past records have what ever date I have
put on the GageInfo page??
Forms![GageInfo]![DateOfLastCal]
How can I get tthe records to only show for each new record what ever I put
on the first form GageInfo??

 

[John W. Vinson]

How can I get tthe records to only show for each new record what ever I put
on the first form GageInfo??

You'll need to store the date in a table field, especially if you want to
reference the date for the record in the future.

Data is NOT stored in forms. If you have a textbox on the form with a control
source of =Date() (as appears to be the case) that information isn't stored
anywhere - it just pulls the date from the computer clock and shows it on the
form, without affecting anything else in your database. However you can have a
table field with a default value of =Date(); that data will be stored with the
record and can be displayed wherever the table is referenced.

 

[jo]

Hi John
the field is called DastOfLastCal, the date that is put in that field on the
first form is stored in a table, the 2nd form (a query based on the first
form and 2nd table)where other values are entered the DastOfLastCal will
change all the past records to the date entered on the first form. So for
example they will all say todays date instead yesterday or last week??? Maybe
I need to do an expression in the query that will do DastOfLastCal but tie it
up with the date/time it was first entered??? En ideas?? please

 

[John W. Vinson]

Hi John
the field is called DastOfLastCal, the date that is put in that field on the
first form is stored in a table, the 2nd form (a query based on the first
form and 2nd table)where other values are entered the DastOfLastCal will
change all the past records to the date entered on the first form. So for
example they will all say todays date instead yesterday or last week??? Maybe
I need to do an expression in the query that will do DastOfLastCal but tie it
up with the date/time it was first entered??? En ideas?? please

I'm sorry, but this is making no sense at all.

What are your Tables? How are they related? What are the Recordsource
properties of the two forms? At what point is DateOfLastCal entered and how?

 

[jo]

hi john sorry I am not explaining myself well.
Table1: GaugeInfo
Field: LastDateOfCal
Table2: CalibrationInfo
Both tables linked by GaugeID

GaugeInfo is the front page of my database that holds the basic infor for a
gauge. CalibrationInfo holds the calibration info for thegauge for every
time the gauge gets calibrated. So user would open the database find the
gauge enter the new LastDateOfCal date then go to calibrationInfo page and
update the new calibration values.
Would like LastDateOfCal to shown on GaugeInfo to show on the
CalibrationInfo but when I put Forms![GaugeInfo]![DateOfLastCal] to copy the
field from GaugeInfo table then I find that all the records for that gauge
all changed to the same date?? I hope I have explained a bit better now
hopefully????
Thanks Jo

 

[John W. Vinson]

hi john sorry I am not explaining myself well.
Table1: GaugeInfo
Field: LastDateOfCal
Table2: CalibrationInfo
Both tables linked by GaugeID

So there's a GaugeID field in both tables? How (if at all) are the tables
related?

GaugeInfo is the front page of my database that holds the basic infor for a
gauge.

DON'T confuse data *presentation" - "front page" - with data storage!!!!

CalibrationInfo holds the calibration info for thegauge for every
time the gauge gets calibrated. So user would open the database find the
gauge enter the new LastDateOfCal date then go to calibrationInfo page and
update the new calibration values.

Why not just have a Form based on GuageInfo and a Subform based on
CalibrationInfo, sorted by LastDateOfCal?

Would like LastDateOfCal to shown on GaugeInfo to show on the
CalibrationInfo but when I put Forms![GaugeInfo]![DateOfLastCal] to copy the
field from GaugeInfo table then I find that all the records for that gauge
all changed to the same date?? I hope I have explained a bit better now
hopefully????
Thanks Jo

Each record in CalibrationInfo should have a date of calibration.
The field LastDateOfCal *SHOULD SIMPLY NOT EXIST*, period, since it can be
determined from the CalibrationInfo table.

You can put a textbox on the form with a control source

=DMax("[DateOfCal]", "CalibrationInfo", "[GuageID] = " & [GuageID])

to dynamically *look up* the most recent calibration date, without storing it
redundantly in any table.