Option box value not retaining value as one moves from record to record

[cheyanne]

Hi

I am trying to produce an option group to sit on a form which will allow a facility to offer discounts to Clients.
The range of discounts on offer is 0% 5% 10% 15% 20% 25%.

I have developed the option group and when you are on a specific record and make a % discount selection, the mathematics
function as intended. If, for example, you insert £250.00 into the amount text box, and select the 20% option from the option group


the discount text box then shows £50.00 discount and the Total box (the amount to pay) as £200.00. All well and good so far.


The problem comes when I return to a previous record and find that, although the discount text box still reads, in the example
above, £50.00, the option box for "20% discount" is not highlighted and so one cannot readily see exactly which option box
was selected for that particular record. I have tried refreshing the records on opening the form, requerying the group frame
(named fraDiscount) but all to no avail. Does anybody know how to resolve this annoying problem?


I have also tried various combinations of VBA code to store the group option box value (reading 1 to 6), to a new text field, but
again no joy. It is possible that I was not referencing the option group values correctly. I have attached a screenshot of the VBA
code used for the calcuations.

I havealso enclosed a screenshot of the form on which the group option selections reside.

Any assistance would be much appreciated.

Thanks

Cheyanne

[RuralGuy]

The OptionGroup needs to be bound to a field in your RecordSource.