Combo box behaviours

[g0ste]

Hello guys!

I have a small problem:

I wish to create a combo box that contains numbers, 1, 2, 3... etc. These numbers are tied to text (for example - 1 = bob, 2 = fred, 3 = harry). I want the combo box to have a number in it to start (say 1), then when clicked, list the names of the values (bob, fred, harry instead of 1,2,3) in the same box. Once a selection is made, I want the number return in the box again.

I am not even sure if this is possible!

I know this is kinda badly described, but I think it is the best way to describe it!

Thanks in advance!!

Dan

 

[ProgramError]

Assuming you have two fields in your table, number and name, then use the bound to column property of the combobox to select the 2nd field and use the column widths to show just the first field ie 5cm,0cm.



Ian Mayor (UK)
Program Error
There's ALWAYS more than one way to skin a cat!
But only one way to get it RIGHT!

 

[g0ste]

Ah hello, Ian.

Thanks for your swift reply!

So in essence, we will be showing the id and the text in the two fields?

I have six fields on the table (and working in design view of the form). Should I be working in the table design view?