Simple Question?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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)
Click to expand...

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.
 
Back
Top