Inserting Combo Box Values

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

Hello,

I am attempting to create a combo box on a form with named values for
different departments, ie: Sales, Dev, or Marketing. In my table the values
for the field I am inserting to are 1, 2, or 3. I want my form to translate
Sales into 1 and insert it. Can someone please provide an example of how
this is done, or perhaps an explanation?

Thanks!
 
I'll assume you are using a Value List for your combo box. You need to set
the properties as follows:

Row Source Type: Value List
Row Source: 1;Sales;2;Dev;3;Marketing
Column Count: 2
Column Heads: No
Column Widths: 0";1"
Bound Column: 1
List Width: 1"

That should do it.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Yes you are correct Roger, and that took care of it. Thanks for the reply!

Cheers!
 
Back
Top