Caption

[Bob Betts]

How do i make a caption of a form equal to a field in a table...

example Tablename : tblCOMPANY
Field : co_name

on the on load event of a form do i put a code like

me.caption=

![tblCOMPANY]![co_name] .....

 

[Nikos Yannacopoulos]

Bob.

What you need is a DLookup function:

Me.Caption = DLookup("co_name","tblCOMPANY","co_ID=" & Me.txtCo_ID )

where I have assumed there is a txtCo_ID control on the form, holding
the companyID, which is stored in field co_ID in the table.

HTH,
Nikos

 

[Nikos Yannacopoulos]

Oops... forgot to say that will only work with a numeric co_ID; in case
it is text, the expression should be:

Me.Caption = DLookup("co_name", "tblCOMPANY", "co_ID='" & Me.tctCo_ID & "'")

(in one line, in case it gets wrapped in your newsreader!).

 

[Bob Betts]

Thanks Nikos.. will try it out...

Oops... forgot to say that will only work with a numeric co_ID; in case
it is text, the expression should be:

Me.Caption = DLookup("co_name", "tblCOMPANY", "co_ID='" & Me.tctCo_ID & "'")

(in one line, in case it gets wrapped in your newsreader!).

How do i make a caption of a form equal to a field in a table...

example Tablename : tblCOMPANY
Field : co_name

on the on load event of a form do i put a code like

me.caption=

![tblCOMPANY]![co_name] .....

 

[Bob Betts]

by the way... what's the co-id for... i have only two fields.. name and
address..

Oops... forgot to say that will only work with a numeric co_ID; in case
it is text, the expression should be:

Me.Caption = DLookup("co_name", "tblCOMPANY", "co_ID='" & Me.tctCo_ID & "'")

(in one line, in case it gets wrapped in your newsreader!).

How do i make a caption of a form equal to a field in a table...

example Tablename : tblCOMPANY
Field : co_name

on the on load event of a form do i put a code like

me.caption=

![tblCOMPANY]![co_name] .....

 

[Nikos Yannacopoulos]

Bob,

Like I said in my original answer, I assumed co_ID to be the PK field in
tblCOMPANY. It's probably called something else, just substitute the
actual field name.

Nikos

by the way... what's the co-id for... i have only two fields.. name and
address..

Oops... forgot to say that will only work with a numeric co_ID; in case
it is text, the expression should be:

Me.Caption = DLookup("co_name", "tblCOMPANY", "co_ID='" & Me.tctCo_ID &
"'")

(in one line, in case it gets wrapped in your newsreader!).

How do i make a caption of a form equal to a field in a table...

example Tablename : tblCOMPANY
Field : co_name

on the on load event of a form do i put a code like

me.caption=

![tblCOMPANY]![co_name] .....