keep things the same

G

Gonzosez

I have an application that uses the same title in several different places
on a form or report
for example lbl1.caption = "bob"
and I want lbl2.caption to = lbl1.caption
I know I can refer to lbl1 in the properties sheet for lbl2 but I forget how
to do it.

something like =[form]![lbl1]![caption]

Help
 
J

Jeff Boyce

If all these objects are on the same form (report), you could use something
like:

Me.lbl2.Caption = Me.lbl1.Caption

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
G

Gonzosez

There is a way to do it on the properties sheet.
Jeff Boyce said:
If all these objects are on the same form (report), you could use something
like:

Me.lbl2.Caption = Me.lbl1.Caption

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


Gonzosez said:
I have an application that uses the same title in several different places
on a form or report
for example lbl1.caption = "bob"
and I want lbl2.caption to = lbl1.caption
I know I can refer to lbl1 in the properties sheet for lbl2 but I forget how
to do it.

something like =[form]![lbl1]![caption]

Help
Click to expand...
Click to expand...
 
D

DrZilboorg via AccessMonster.com

Jeff said:
If all these objects are on the same form (report), you could use something
like:

Me.lbl2.Caption = Me.lbl1.Caption
Click to expand...
If I wanted the value to be the same, for example, transferring a cost value
from one table to another can I use a similar format?

Me.tblName1.Column.value = Me.tblName2.Column.value
 
J

Jeff Boyce

No.

In a well-normalized relational database, it is rarely necessary (or
appropriate) to copy values from one table to another. What is it that you
are trying to copy?

By the way, you'll get more "eyes" on your post if you don't tuck it in
underneath an existing thread...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Top