Show a field on a form not in record source

[Cozmo2]

I have a form that has data & several command buttons that open other secondary forms. I want to put a field from one of the secondary forms onto the primary form. What is the best way to accomplish this?
Thanks for any help you can give me.

 

[MajP]

take a look at the dlookup function.

 

[Cozmo2]

#error is returned on my form. here is my code (in Control Source): =DLookUp("Area","[Graduation Information]","[soc_sec] = Forms![Graduation Information]!soc_sec").
Area is a Field in the Graduation Information Table

Where am I going wrong?
Thanks for you help.

 

[PHV]

What about this ?
=Nz(DLookUp("Area","[Graduation Information]","[soc_sec] = Forms![Graduation Information]!soc_sec"),"")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Cozmo2]

Thanks for your response. Unfortunately, the
#error is still returned on my form. I tried changing Forms to Table, didn't help. I also added Tables! before the first "[Graduation Information]" like this:
=Nz(DLookUp("Area","Tables![Graduation Information]","[soc_sec] = Forms![Graduation Information]!soc_sec"),"") and received:
The Microsoft Jet database engine cannot find the input table or query Tables![Graduation Information]. Make sure it exists and that its name is spelled correctly. The table does exist.

 

[PHV]

DLookUp("Area","[Graduation Information]","[soc_sec] = Forms![Graduation Information]!soc_sec")
Obviously [Graduation Information] is an open main form with a populated control named soc_sec, and soc_sec and Area are some fields in the [Graduation Information] table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Cozmo2]

Graduation Information is a form that can be accessed through a command button on the main form StudentInformation. Graduation Information is not opened. The Graduation Information table does contain the soc_sec and the area fields.

 

[PHV]

Graduation Information is not opened.
So, the #Error is normal behaviour ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Cozmo2]

Can I perform a Dlookup on a table that is closed?

 

[PHV]

The problem is not the table but the form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Cozmo2]

Thanks for the help. I think I need to figure out a different approach.