Inserting Combo Box Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jordan - 01 May 2008 17:42 GMT

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!

Reply to this Message

Roger Carlson - 01 May 2008 19:07 GMT

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.

Signature

--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

> Hello,
>
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Jordan C. Schroeder - 02 May 2008 18:49 GMT

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

Cheers!

> I'll assume you are using a Value List for your combo box. You need to set
> the properties as follows:
[quoted text clipped - 20 lines]
> >
> > Thanks!

Reply to this Message