Filling a form field using check boxes

[Miguel54]

This is way above my head: I have a form with check-boxes for different
options, each option representing a living arrangement such as "owns a home,"
"rents," Is Single," etc. Further I have each check-box additionally titled
as "A" "B" etc for each arrangement so I can have those alphabetical
designations appear in a form field (and there will usually be more than
one). I would like to select one or more check-boxes and have either numeric
(1,2,3,...) or alphabetical (A,B,C,...) results appear in this form field.
Ideally, if you deselect a check-box, it would disappear from the form field,
but that may be too much to ask.

Is this doable at all? If so, how?

 

[Jeff Boyce]

It all starts with the data ... and I'm not visualizing your underlying
tables yet...

Access stores data in tables, and displays it in forms.

Please describe the data structure first...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.