Toggle Buttons

[SamDev]

I'm working in Access 2000 and I have a form that someone else created.

There are 3 rows with 9 toggle buttons that are numbered (captioned) 1, 1.5,
2, 2.5, 3 etc and the option value assigned to each is 10 times the label
amount. For example the option value on the toggle button 1 = 10.

It only permits one selection per row. When a button is clicked the amount
(caption) is the amount selected automatically changes the value of a
separate control. For example if the 2 is pressed in row 1, 3 in row 2 and
4 in row 3 the total displayed in the separate control would be 9.

Each row represents a different level of scoring. And the control that
changes as each toggle button is selected totals all scores from each level.

The source for the form is a query and when a toggle button is clicked the
option value is transferred to a query field. But I don't see any where on
properties of the toggle buttons where it is linked to those fields or how
it is knowing to add the individual scores to come up with the total for all
levels.

Any help would be appreciated.

Thx!!!

 

[Tony Vrolyk]

See inline comments.

It only permits one selection per row.

Sounds like each row is an option group. If so any code that executes is
attached to the group and not each individual toggle. In design view click
the border surrounding each group and check code attached to it. The border
may be hard to see if it is tight around the toggles - but it is there.

The source for the form is a query and when a toggle button is clicked the
option value is transferred to a query field. But I don't see any where on
properties of the toggle buttons where it is linked to those fields or how
it is knowing to add the individual scores to come up with the total for
all levels.

I am guessing that the value of the groups is used by code to do the
appropriate math and than devide by 10 to get the end result. Toggles can't
have decimal values so that is why they are set to be 10 times higher.

Hope that helps
Tony V