#NAME? Error on form

[David1234]

Hi,

I'm trying to multiply two values, one from the main form, one from the subform into a total on the main form.

I've set the expression in the control source as this..

[RH_TOTAL_CREDIT1]=([RH_QTY_CREDIT1]*[Forms]![Stock_Form1]![STK_BASEPRICE])

Is that completely wrong!!?

 

[PeterF]

I assume "RH_TOTAL_CREDIT1" is the control name where you want to display the total, you shouldn't include it in the control source.

=([RH_QTY_CREDIT1]*[Forms]![Stock_Form1]![STK_BASEPRICE])

 

[David1234]

Hi Peter,

Thanks for the reply, the error has persisted. Is it something in the set up i'm doing wrong?

I have the field, drop it onto the form the results are needed on. I then enter the properties of the form and then enter the code you suggested.

David

 

[Swemebegur]

Hi David1234

The code should read:

=([RH_QTY_CREDIT1]*[Forms]![Stock_Form1].Form![STK_BASEPRICE])

Assuming that "Stock_Form1" is the name of the control on the main form.

HTH

Swemebegur

 

[David1234]

No joy on this either.

Stock_Form1 is an subform pulling in one record dependent on the stock code entered in by the user. So, if the user enters code 12-345-678 the subform will check the datasource and provide the cost price.

Is it because I am adding a field from the main form with a field from the subform with a result back on the main form?

David