Controlling the output of a scroll-down menu

[fluidmind]

Hi again!

This time I'm having some problems finding a way to determine the output of a scroll-down menu (or in my danish version of Access called "combination-box").

In the menu I can choose between a number of names from a table. But when I select the name and press the "OK" button that stores the data, only a number (and not the choosen name) is written in the table. How can I get the output-value of the drop-down to be the choosen name???

Please give me a simple answer and a simple solution... I'm a total newbie!!

// JR

PS. Mike, feel free to reply... I kinda like your style

 

[MaliciousMike]

Hi again!

This time I'm having some problems finding a way to determine the output of a scroll-down menu (or in my danish version of Access called "combination-box").

In the menu I can choose between a number of names from a table. But when I select the name and press the "OK" button that stores the data, only a number (and not the choosen name) is written in the table. How can I get the output-value of the drop-down to be the choosen name???

Please give me a simple answer and a simple solution... I'm a total newbie!!

// JR

PS. Mike, feel free to reply... I kinda like your style

Put this in your row source for the combo box, chaning Name to the field you want displayed and MyTable to wherever the data is stored:

SELECT [Name] FROM MyTable ORDER BY [Name];

Change Column count to 1, and bound column to 1

Hope this helps.

 

[fluidmind]

Thanks again!

It works! Thanks again!