Help to kill a #Name?

[LarryS]

Being rusty at access programming, I need help resolving a #Name? problem.
I developed a calculating form that is populated with several fields from an
entry form.
The information populates when the quote number is entered.
The relationship between the two tables is established as a 1-to-1 using that
quote number.
My problem is the expersion I created -
=[Material Cost]*[Request For Quote]![RLength]/12
I know the problem is the [Request ...] because when I replace it with a
number the formula works.

 

[Beetle]

If [Request For Quote] is a separate form then you'll need something like;

=[Material Cost]*[Forms]![Request For Quote]![RLength]/12

If [Request For Quote] is a subform of the form that your calculated
control is located on, then;

=[Material Cost]*[Request For Quote].Form![RLength]/12

If [Request For Quote] is a subform on a separate form, then;

=[Material Cost]*[Forms]![TheOtherForm]![Request For Quote].Form![RLength]/12