Hallo! http://www.access-programmers.co.uk/ubb/smile.gif)

I have a combo box were I select the value that appears each time. What I want is, whenever I select a value (in this case it’s a currency) for instance EURO I want it’s IDNumber to be automatically appear on another box. To explain better
I choose EURO in the combo box named “currency” the IDNumber “300” automatically appears to a text box. If I choose DM I want the no “400” to be appeared etc.
Can u please help me????


[This message has been edited by Joanna_gr (edited 03-25-2002).]

You can do what you're asking a couple of different ways. Are you familiar with Dlookup()? Also you could add an invisible column to oyur combo box that holds the 'code' and then put that into a separate box (for display only) when you select the right currency type.

Post back if you need more details, but there is quite a bit on this in the archives of this forum.
Good luck,
David R

Try this topic: http://www.access-programmers.co.uk/ubb/Forum4/HTML/000550.html