How to Relate an "If Other Please List" Memo/Text box to a Combo

[skyrise via AccessMonster.com]

I am creating a database using Access 2007.
The database has lookup tables that appear as Combo Boxes on the main form.
Some of the combo boxes have an "other" option.
If "Other" is selected in the combo box, then the user is to enter the
information in a text or memo box.

Example Combo Box:
Option1
Option2
Option3
Other

I'm not sure how best to set this up so that everything is related properly.

I was thinking that I could create a subform with a field for the combo box
and a field for the text/memo box. However, the users won't be entering
multiple lines of selection. They will be selecting only one Combo Box item
per Form Record. So, I don't think that this is the best approach.

Is it possible to have the Combo Box as a field on the Form and the Text/Memo
box as a field on the form?
If so, how would I do this and what kind of relationships do I need to
establish?

The database will have approximately 10 of these.

I appreciate any assistance/ideas received.

 

[Allen Browne]

Use 2 fields in your table:
OptionID the number field the combo box is bound to
Descrip the text field where the comment can be entered.
The description is available regardless of the option chosen, but is
expected if the 'other' option is chosen.

If you want to, you can take it further. Typically you will have a lookup
table that explain what these options are; it acts as the RowSource for the
combo. You could add a field to this table to indicate if the Descrip is
expected. You can then use the LostFocus event of the combo to SetFocus to
the 'Descrip' field if one is expected, or to skip that field if it was one
of the other options.