Displaying a field value in a different form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Click to expand...
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.
 
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.
 
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
Click to expand...
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
Click to expand...
the control source? If so, which event am I supposed to use?
 
Back
Top