Inserting Combo Box Values

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/...UBED1=ACCESS-L

"Jordan" wrote in message
...
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!

Yes you are correct Roger, and that took care of it. Thanks for the reply!

Cheers!

"Roger Carlson" wrote:

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/...UBED1=ACCESS-L

"Jordan" wrote in message
...
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!