When i open the form some field shows #name?

[meenctg]

I have a continuous view type form. There is a sub form. In the sub form i have a calculate field in the footer.

I wanna use the calculate field result in the main form. When i use a unbound text box for the result of these. Its show #name?

How to i'll solve the problem?

I have included an image.

 

[John Big Booty]

the #name error indicates that Access is unable to find the control that you are referring to in the control.

You can either use the expression builder to get the correct reference for the control you wish to display or use this link to get the correct syntax for the reference manually.

 

[meenctg]

the #name error indicates that Access is unable to find the control that you are referring to in the control.

You can either use the expression builder to get the correct reference for the control you wish to display or use this link to get the correct syntax for the reference manually.

My main form name: Todays_status_sell_Pay_due_part
Sub form name: TodayS_due_payment

I have used in main form in a text box
Me!TodayS_due_payment.Form!Text38.Enable

Still it shows #name?

 

[John Big Booty]

Try;

= Forms!Todays_status_sell_Pay_due_part!TodayS_due_payment.Form!Text38

 

[meenctg]

Try;

= Forms!Todays_status_sell_Pay_due_part!TodayS_due_payment.Form!Text38

Still it showing #name?

 

[John Big Booty]

Try using the expression builder to construct your reference.

 

[meenctg]

Try using the expression builder to construct your reference.

I created expression builder with
= Forms!Todays_status_sell_Pay_due_part!TodayS_due_payment.Form!Text38
but yet it shows #name?