advice on how to best do this, please?

[-Deborah-]

I need to create a form that will have 4 groups of options or checkboxes
(or whatever will actually work). As an option is checked, a value for
that option will display in a text field. As additional options are
checked, their values are appended to that text field. Like:

[ x ] 4.1
[ ] 4.2.1
[ ] 4.2.2
[ x ] 4.2.3

[ ] 5.1
[ x ] 5.2
[ x ] 5.3

The text field would now display: "4.1, 4.2.3, 5.2, 5.3"

Any advice on how to best implement this is greatly appreciated.

[Al Campagna]

Deborah,
Try string concatenation. Since you need to select several values,
you'll need to use individual check boxes, not option groups, and each
checkbox must be bound to it's own field.
For the sake of ease, let's say the check fields are "named" 41, 421,
422, etc.
In an unbound Text control, set the ControlSource to...
=IIF(41=True,"4.1","")&", "&IIF(421=True,"4.2.1","")&",
"&IIF(422=True,"4.2.2","").... etc for all the individual checkbox elements.

This will create a concatenated string of all the True checkbox values.

But, since the form displays all the checkboxes, thier values, and
whether they are checked or not... is it really necessary to then
concatenate the values to a text box for "display". I would think the user
could just look at the checkboxes to see what values are active.
--
HTH
Al Campagna
Candia Computer Consulting
Candia, NH

"-Deborah-" <deb...@invalid.work.com> wrote in message
news:3EB26464...@invalid.work.com...

---
Outgoing mail is certified by AVG 6.0 as Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.471 / Virus Database: 269 - Release Date: 4/10/03

[-Deborah-]

Al thank you so much for your response! I should have mentioned that
these values would actually be going to a different form for the user's
reference. Thanks again.