keep things the same

[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

 

[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/

 

[Gonzosez]

There is a way to do it on the properties sheet.

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/

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

 

[DrZilboorg via AccessMonster.com]

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

Me.lbl2.Caption = Me.lbl1.Caption

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

 

[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/