Displaying a field value in a different form

[Lee]

I have a main form that identifies who should be working on a particular project. I'd like to carry that person's name to the detailed form and tried this by creating a new text box and the formula =Forms![Table name]![Field Name] in the control source for the detailed form.

Unfortunately, I get #Name?. Do you know what I should do instead?

 

[Gerald Stanley]

Try using the syntax
Forms![Form Name]![Control Name]

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
I have a main form that identifies who should be working

on a particular project. I'd like to carry that person's
name to the detailed form and tried this by creating a new
text box and the formula =Forms![Table name]![Field Name]
in the control source for the detailed form.

 

[Lee]

Thanks for the syntax; but, I typed it into the control source ...with the form name this time...and still got the same result. What's strange is that Access automatically put the brackets around [Form].

Am I supposed to build an event instead of typing it into the control source? If so, which event am I supposed to use

Thanks for your help.

 

[Gerald Stanley]

You could try putting code into the form's Load
eventhandler along the lines of
Me!controlName = Forms![Form Name]![Control Name]

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Thanks for the syntax; but, I typed it into the control

source ...with the form name this time...and still got the
same result. What's strange is that Access automatically
put the brackets around [Form].

Am I supposed to build an event instead of typing it into

the control source? If so, which event am I supposed to use?