I have a table with a field called ProjectPhaseID, and another which
shows the ProjectPhaseID and ProjectPhaseName. On the data enty form, I
want to display the ProjectPhaseName as radio button options and when
the data is committed, I want to store the ProjectPhaseID. How do I do
this?

Thanks

"Fendi Baba" <effendi@epitome.com.sg> wrote in
news:1142148515.335026.86020@u72g2000cwu.googlegro ups.com:
[color=blue]
> I have a table with a field called ProjectPhaseID, and another
> which shows the ProjectPhaseID and ProjectPhaseName. On the
> data enty form, I want to display the ProjectPhaseName as
> radio button options and when the data is committed, I want to
> store the ProjectPhaseID. How do I do this?
>
> Thanks
>[/color]
put the projectPhaseId for each option into the optionValue
property.


--
Bob Quintal

PA is y I've altered my email address.

Thanksa for your suggestion. It worked but the only problem is the
labels are ahrd coded. I need it to come from another "table".

"Fendi Baba" <effendi@epitome.com.sg> wrote in
news:1142187218.110171.231870@j33g2000cwa.googlegr oups.com:
[color=blue]
> Thanksa for your suggestion. It worked but the only problem is
> the labels are ahrd coded. I need it to come from another
> "table".
>[/color]
make the table and copy the labels to the description field.

You will then need to create some Visual Basic code to read from
the table and assign the labels to the option button labels.


--
Bob Quintal

PA is y I've altered my email address.