List Box to Act Like an Option Group??

[despatcher]

Hey,

May sound silly but please bare with me.

What i have done!

In Option group i can set label names that have a value i can then store this value in another field.

This is great and exactly what i want however the amount of labels / options i want is quite large and these all apear on the form as radio buttons or switches (My choice)etc. I dont have space for these and they make the form look a mess.

What i want!

I want my options in a list box that does the above.

i.e I select my option from the list box and it returns the value of my selection (the figure 1 for example) to another field on my form.

I am certain this is far from impossible and any help would be appreciated

 

[pbaldy]

If you have a table with the number in one field and the description in another, the listbox wizard would create a listbox that did what you want.

 

[despatcher]

Job done

didnt quite do it as you said but went about it in a similar way

very simply created a combo box with two columns data in one numerical value in other set focus to second column and told it to place the numerical value into a different text box on form i think i posted to early but thanks for steering me in the right direction

 

[despatcher]

Thought i Had Solved this

Read he previous post and you would think i solved this already.

I have a large db that has been running succesfuly for a while i need to tweak something slightly but don't want to have to change everything

What i had

Within my forms i had a field for Title: Mr, Mrs, Miss Doctor, Nurse the list goes on 12 in total. Basically you just typed this in

Another field was Title Rank Code in order that all the Doctors details appeared first on a report and then the nurses followed by the others in the sequence i wanted (Rank alphabetical if you like) i gave each one a number from 1 through twelve and this worked by basically making the report ascend this field along with their surnames. WORKS PERFECTLY WELL

NEW BOSS

Doesn't want line managers to have to remember what number corresponds with someones title.

So here it is i want to create a drop down that will

1. Have all possible titles in
2. Place the corresponding number of that title in theTitle Rank Code Box
3. Place the Text selected from the drop down into the original title box

The reason for No3 is so that i dont have to ammend all reports query etc i can just place the combo box on top (effectively hiding) of the original Title field and this shouldnt take too long then to ammend the db

see previous pot to see how i thought it was done i basically had no1 and 2 but cant get 3 to work

thanks in advance hope this wasnt to long winded

 

[pbaldy]

3 would be the same as 2, but referring to a different column from the combo.

 

[despatcher]

3 same as two

combo wizard only offered me the option of placing data from one column to another field

i tried to do an after update along the lines of

textbox1=mycombobox.column(1)

but this asked for a Macro

My appologies i got my head into Access a year or so ago to design the db i hve just been asked to tweak it but have forgotten almost all of the basics

it certainly isn't like riding a bike because i cant get back on

 

[pbaldy]

Well, this works for me:

Me.Driver_name = Me.cmbDriver.Column(1)

where the first column (0) contains an employee number, and the second (1) contains the name.