In English, what I am trying to achieve is by evaluating the Option Group's Value:

If optionGroup.Value = 1 Then

TotalPrintCost = PrintCost

Else if optionGroup.Value= 2 Then

TotalPrintCost = PrintCost * Quantity

Else

TotalPrintCost = (Quantity/1000)*PrintCost

PrintCost and Quantity are fields in the table, as well as textboxes in the form. Part of the problem is I'm not sure if I should be using the table fields or the form objects to do the calculations.

I have been going round and round with this - I feel like there is such a simple answer that I am missing!

Any help would be appreciated