Link frame to combo box.

[indesisiv]

Think this may be me going daft but:
I have a combo box already set up and i want it to update to a name in that list when one of the option buttons in the frame has been clicked.

I tried to link it throught the value's but it just throws a number into the combo box and not the word in the combo box.

Any help greatly recieved.

Thank you all

Steve

 

[PaddyIrishMan]

Hi,
It sounds like the Id's rather than the textual names are going into the ListBox, do you have Multiple columns in the Listbox - if so, try changing the BoundColumn which is probably set to 0 to 1

Regards,
Patrick.

 

[indesisiv]

No .. just a single bound column no others ...
If it helps the combo box is a Value List

 

[Tay]

Hi


If you have both the name of the field you want as well as the ID number (value that you spoke about?) in the SQL, it may just be that you have the combo just looking at the ID number column. If that's the case, change it so that the column you want (name) appears (type the column No into 'bound column').

If not, post the SQL in the recordsource in the combo.

HTH

 

[PaddyIrishMan]

Are the numbers displayed just zeros & ones? I.e. the Option button.value True/False?

 

[indesisiv]

the values are coming from a frame ... 1-5
they have no relevance to the combo box as such ... just wanted to know if there is a way of selecting an option button in the frame and displaying and equivalent text in the combo box ...

Think that it is looking increasingly likley that i will have to add another bount number ID field into the combo box and do it that way.

 

[indesisiv]

Thanks for your help

I have set it up to grab the valuses from a table and bind the values in a hidden column ... does the job and is probably the best way of doing it ...

Thanks for all your help ... think it was a monday morning mental block not thinking of doing it that way.

Cheers
Steve