If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Inserting Combo Box Values
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! |
#3
|
|||
|
|||
Inserting Combo Box Values
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! |
Thread Tools | |
Display Modes | |
|
|