S
Synth
Guest
I am using Access 2002 (From Office XP SP2).
I have this form which contains three items: text01, q3 and cost01.
text01 = text box which the user inputs the number of the item wanted.
q3 = a query which returns the cost of the particular item.
cost01 = a text box which is supposed to display the total cost ie, text01 * q3
In the Control Source section for control cost01 I put:
= [text01] * [q3]![Cost]
This gives me the error "#Name?" displayed in the box.
I tested q3 by itself (In Query Section) and it works fine. I also tested "= [text01]" alone and it works correctly.
Any ideas?
I have this form which contains three items: text01, q3 and cost01.
text01 = text box which the user inputs the number of the item wanted.
q3 = a query which returns the cost of the particular item.
cost01 = a text box which is supposed to display the total cost ie, text01 * q3
In the Control Source section for control cost01 I put:
= [text01] * [q3]![Cost]
This gives me the error "#Name?" displayed in the box.
I tested q3 by itself (In Query Section) and it works fine. I also tested "= [text01]" alone and it works correctly.
Any ideas?
