<p>I have two forms in microsoft access, one called Bill and the other one called Payment. They both have Total amount as a field in both of the forms. I am trying to reference the Bill total amount to the Payment total amount. </p>

<p>I have tried in the Payment total amount control source : =Forms!Bill![Total Amount]</p>

<p>but this doesnt seem to work. In Design view it says '#Name?' in the text box. </p>

<p>How would you do this? </p>

Is either of the forms a subform? If so, you need to reference the subform control or the parent property:
```
```
Me.Parent.[Total order]
Me.[Subform Control name Here].form.[Total order]
```
```
Note that the Subform Control name  is not always the same as the form contained.
EDIT: Either omit Me or use Form!FormName in a control.
EDIT2: Please note that the usual way of referencing forms, subform and controls is with either bang (!) or dot (.). parentheses and quotes are rarely used. This can be seen in both the Microsoft Access MVPs site (
http://www.mvps.org/access/forms/frm0031.htm
) and Microsoft's own site (
http://support.microsoft.com/kb/209099
), as mentioned by Knox.
If not, have you tried the Expression builder? It will help ensure that you have the correct names.
As an aside, it is best to avoid spaces in the names of fields and controls, it will save you a good deal of work. It is also best to rename controls so they do not have the same name as the fields they contain, txtOrderTotal, for example.