Checkboxes - How do I display values from a reference table

[Fendi Baba]

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

[Bob Quintal]

"Fendi Baba" <ef*****@epitome.com.sg> wrote in
news:11*********************@u72g2000cwu.googlegro ups.com:

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

put the projectPhaseId for each option into the optionValue
property.
--
Bob Quintal

PA is y I've altered my email address.

[Fendi Baba]

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

[Bob Quintal]

"Fendi Baba" <ef*****@epitome.com.sg> wrote in
news:11**********************@j33g2000cwa.googlegr oups.com:

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

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.