show calculated control from one subform on another subform

[Guest]

Mainform: Patient

Subform1: Intake
control: [Text22]
control source="Intake #" & ((Count(*)+1)-(rownum([Form]))) & " of " &
(Count(*)) & " intake(s)"


Subform2: Visit
i want text 22 to be shown on subform2.
i created text box [text100]
control source=subform2!text22

my subform2 shows "#name?" on display.

can someone give me the correct syntax. i thought this was right based on
perusing the forum. could there be something wrong since it is a calculated
control?

thanks for any help.

patti

 

[Jeff L]

=Forms!MainFormName!Subform1!Text22

You might consider naming your fields with more meaningful names, other
than Text22. You will find it a lot easier when you should have to
debug something. If someone should happen to inherit your database,
they won't be cursing you if you have meaningful names for your fields.
I work with a guy that uses the Access defaults all the time and it
drives me insane when I have to try and fix something he has worked on.
Ok I'm off my soap box now.

Hope that helps!

 

[Guest]

Jeff-

Thanks for the speedy reply! Got my form working.

I rename all the controls after it gets working. it's probably more
laborious this way but i am deleting and recreating controls until i figure
it out. This is my first db and i have learned a lot from these forums and
will name-as-i-go once i get more fluent in access. And i definitely am
looking out for the next guy taking over this db!

Thanks very much for all the advice and suggestions.

=Forms!MainFormName!Subform1!Text22

You might consider naming your fields with more meaningful names, other
than Text22. You will find it a lot easier when you should have to
debug something. If someone should happen to inherit your database,
they won't be cursing you if you have meaningful names for your fields.
I work with a guy that uses the Access defaults all the time and it
drives me insane when I have to try and fix something he has worked on.
Ok I'm off my soap box now.

Hope that helps!

Mainform: Patient

Subform1: Intake
control: [Text22]
control source="Intake #" & ((Count(*)+1)-(rownum([Form]))) & " of " &
(Count(*)) & " intake(s)"


Subform2: Visit
i want text 22 to be shown on subform2.
i created text box [text100]
control source=subform2!text22

my subform2 shows "#name?" on display.

can someone give me the correct syntax. i thought this was right based on
perusing the forum. could there be something wrong since it is a calculated
control?

thanks for any help.

patti