Value from subform

[javajom]

Hi,
What I have done is made a form which shows the user by a if statement:

If([Type]="Orpheus 10x6x10",32,IIf([Type]="Orpheus 12x8x12",32,IIf([Type]="Orpheus 16x12x16",32,IIf([Type]="AGI 2x2x2  Modified",32,IIf([Type]="AGI 4x2x4",32,IIf([Type]="AGI 6x3x6",32,IIf([Type]="AGI 8x4x8",32,IIf([Type]="AGI 10x6x10",32,IIf([Type]="AGI 12x8x12",32,32))))))))))))

which shows that if the type selected is say 'AGI 2x2x2 Modified' then the value would be '32' , which means I've allowed 32 hours. The problem is that this has just started to be used and figures may have to be changed there are 7 lots of simular statements, which means a lot of changes. So what I've done is to make a exel sheet with all the figures on and then have a linked table from that spreadsheet page so to update figures I would simply change the excel.

From that table I've made a subform and from that subform I need to get the value of the subform and do some maths if needed and place the result into the normal form. I though it would be easy but can't get it right am I getting close or is it not that easy???

Forms!orpheus.Sales.Value = Forms!Figures.Sales.Value

Thanks.

 

[pbaldy]

Here's a handy reference on the syntax:

http://www.mvps.org/access/forms/frm0031.htm