Simple Question?

[Guest]

How do I make the following list box (or drop down box) list several of the
two letter abbreviations into a single field that will be separated by a
comma?

Example:
ID LUC Description
1 AG Agriculture
2 FS Forestry
3 HM Hydromodification
4 MB Marinas & Boating
5 UC Urban / Construction

AG, FS, HM, MB (or any combination)

 

[fredg]

How do I make the following list box (or drop down box) list several of the
two letter abbreviations into a single field that will be separated by a
comma?

Example:
ID LUC Description
1 AG Agriculture
2 FS Forestry
3 HM Hydromodification
4 MB Marinas & Boating
5 UC Urban / Construction

AG, FS, HM, MB (or any combination)

Use a Combo box (or a List Box with it's MultiSelect property set to
None) .....
Code control's the AfterUpdate event:

[FieldName] = [FieldNamel] & Me.ComboBox.Column(1) & ", "

where [FieldName] is a control bound to a field in the table.