Copy a cell from one form to another?

[jo]

Hi Guys I have 3 forms done as tabs. On the first tab the user enters the
main info for gauge required and on the 2nd form is where the user would
update the recent changes to that gauge and the 3rd tab will show all the
history to that gauge, all connected by the GaugeId. Gauge ID on the 1st tab
will show on the 2nd tab (as GaugeId) and also on the 3rd tab, but what I
would like is the LastCalDate on the 1st tab to show on the 2nd tab as well
but I cant seem to do this?
The cell on the 1st tab is called Gauge ID is related to GaugeId on the
second tab, I have tried to relate DateOfLastCal on the 1st tab to
LastCalDate on the 2nd tab but does not work? Can any one help?

 

[John W. Vinson]

Hi Guys I have 3 forms done as tabs. On the first tab the user enters the
main info for gauge required and on the 2nd form is where the user would
update the recent changes to that gauge and the 3rd tab will show all the
history to that gauge, all connected by the GaugeId. Gauge ID on the 1st tab
will show on the 2nd tab (as GaugeId) and also on the 3rd tab, but what I
would like is the LastCalDate on the 1st tab to show on the 2nd tab as well
but I cant seem to do this?
The cell on the 1st tab is called Gauge ID is related to GaugeId on the
second tab, I have tried to relate DateOfLastCal on the 1st tab to
LastCalDate on the 2nd tab but does not work? Can any one help?

First off... Access doesn't use "cells". Forms have Controls; tables have
Fields. Proper naming of parts is important to communicate!

Secondly, your data is not stored in your Form; it's stored in one or more
Tables. Are these three Subforms on separate tab pages of a main form, or do
you have multiple controls on different tabs? What are your Tables? How are
they related? If you're using subforms, what are their master and child link
fields?

Thirdly... are you trying to store LastCalDate redundantly in two tables? If
so... DON'T. You can *display* it on a second tab by using a textbox with an
appropriate control source, but we don't know what's appropriate unless you
post more information about the nature of your form.

 

[jo]

Hi John thanks for yr reply, I am a novice at access so hence not using the
correct naming of parts so hopefully you can bear with me.. They are subforms
on each tab and 2 of those have subforms as well. I am not trying to store
LastCalDate redundantly as each tabs/subforms info is required for other
topics such as reports etc. Thats why its good that GaugeId and Gauge ID
relate but I would like DateOfLastCal and LastCalDate to relate. I take it
these are known as Fields?
Each tab has its own control, does this give you more info???

 

[John W. Vinson]

Hi John thanks for yr reply, I am a novice at access so hence not using the
correct naming of parts so hopefully you can bear with me.. They are subforms
on each tab and 2 of those have subforms as well. I am not trying to store
LastCalDate redundantly as each tabs/subforms info is required for other
topics such as reports etc. Thats why its good that GaugeId and Gauge ID
relate but I would like DateOfLastCal and LastCalDate to relate. I take it
these are known as Fields?

You would be able to tell... I wouldn't, because I can't see your screen from
here! A Field is in a Table and it's where data would be stored. That field
might be displayed on a Form in a Control (such as a textbox or a combo box or
something else).

Each tab has its own control, does this give you more info???

I'm sure each Tab Page has multiple controls on it.

You can refer to a control elsewhere on a Form by creating a textbox with a
Control Source property such as

=[controlname]

For instance, if there is a control named DateOfLastCal on the main form, you
can use

=[DateOfLastCal]

If the control is in a Subform you need to reference the name of the subform
(the subform *CONTROL*, the box containing the form, not the name of the form
itself - they may have the same name but might not):

=[subformname].Form![DateOfLastCal]

 

[jo]

Hi, I have tried as you have suggested but I get this results: #Name?
And I thought this would also make that field redundant for that table and I
need that info to store to use later. I am confused as to why the field
called [Gauge ID] from the 1st form/tab shows in the 2nd tab [GaugeId] as i
wanted but the fields [DateOfLastCal] and [LastCalDate] do not match? Is it
the relationship? although I have tried this with no affect.

Hi John thanks for yr reply, I am a novice at access so hence not using the
correct naming of parts so hopefully you can bear with me.. They are subforms
on each tab and 2 of those have subforms as well. I am not trying to store
LastCalDate redundantly as each tabs/subforms info is required for other
topics such as reports etc. Thats why its good that GaugeId and Gauge ID
relate but I would like DateOfLastCal and LastCalDate to relate. I take it
these are known as Fields?

You would be able to tell... I wouldn't, because I can't see your screen from
here! A Field is in a Table and it's where data would be stored. That field
might be displayed on a Form in a Control (such as a textbox or a combo box or
something else).

Each tab has its own control, does this give you more info???

I'm sure each Tab Page has multiple controls on it.

You can refer to a control elsewhere on a Form by creating a textbox with a
Control Source property such as

=[controlname]

For instance, if there is a control named DateOfLastCal on the main form, you
can use

=[DateOfLastCal]

If the control is in a Subform you need to reference the name of the subform
(the subform *CONTROL*, the box containing the form, not the name of the form
itself - they may have the same name but might not):

=[subformname].Form![DateOfLastCal]

 

[John W. Vinson]

Hi, I have tried as you have suggested but I get this results: #Name?
And I thought this would also make that field redundant for that table and I
need that info to store to use later. I am confused as to why the field
called [Gauge ID] from the 1st form/tab shows in the 2nd tab [GaugeId] as i
wanted but the fields [DateOfLastCal] and [LastCalDate] do not match? Is it
the relationship? although I have tried this with no affect.

I'm sorry, jo, but you're making unwarrented assumptions about my skill and
perception.

I have NO IDEA what tables you have.
I have NO IDEA what forms and subforms you have.
I have NO IDEA how your tables are related.
I have NO IDEA which table these fields might be in.

None of the other volunteers here do either, because *you have not told us*.

We'd love to help, but we need your help to do so.

 

[jo]

Ok John thanks any way..

Hi, I have tried as you have suggested but I get this results: #Name?
And I thought this would also make that field redundant for that table and I
need that info to store to use later. I am confused as to why the field
called [Gauge ID] from the 1st form/tab shows in the 2nd tab [GaugeId] as i
wanted but the fields [DateOfLastCal] and [LastCalDate] do not match? Is it
the relationship? although I have tried this with no affect.

I'm sorry, jo, but you're making unwarrented assumptions about my skill and
perception.

I have NO IDEA what tables you have.
I have NO IDEA what forms and subforms you have.
I have NO IDEA how your tables are related.
I have NO IDEA which table these fields might be in.

None of the other volunteers here do either, because *you have not told us*.

We'd love to help, but we need your help to do so.

 

[GAEL]

je Gael oui