setting toggle button

[Guest]

Hi,

I've got an option group with 2 toggle buttons, Yes and No. I have a combo
box on that same form, when I select a name from the combo box, I would like
to have the current status shown by either setting the Yes or No as active
and be able to change the current status by clicking the toggle buttons. Any
suggestions?

 

[Guest]

Your question is not that clear, but if I understand, you have a combo from
which you select a name. When you select that name, it postions the current
record to that name. When that happens, you want the Option Group to show
the current value for that field in the record and you want to be able to
change that value. If this is what you are wanting, then all you need to do
is bind the option group to the Yes/No field in the recordset. When a record
becomes current, it will change to whatever the value in the table is. If
you change it, it will update the recordset.

 

[Guest]

Hopefully this clears things up a bit:

On a form that is bound to a table containing a field on names [text] and a
field of Y/N reflecting active status. On the form I want to select a name
from a combo box, and have the toggle buttons show whether the Active field
is Y or N, and say it comes up N, I want to be able to change the status of
that person by clicking the Y toggle. Binding the option box to the Active
field didn't help.

Thanks