access 2003 report

[Dragonlight]

I have a database in access. I have also created a form, in this form I have a field that asks

Quantity of Part1 : 1
Cost of Part1 : $99.00
Final cost of Part 1 : $99.00

Now I have created a report.
I want these fields to be visiable in this report, but when I pull up the report, I get.

Quantity of Part1 : 1
Cost of Part1 : $99.00
Final Cost of Part1 : $0.00

I am looking for a way to make "Final Cost of Part1" to give the correct $$ amount.

 

[sxschech]

In the text box on your report enter this in the Control Source of its properties window:

=[Forms]![formname].[txtFinalCost]

Remember to replace formname with the actual name of the form and txtFinalCost with the actual name of the textbox containing the final cost on your form.