ComboBox Value

[Brightspark98]

Hi,

I have a form with several ComboBox controls.

All display the contents but when a selection is made on one of the ComboBox controls only the top value is displayed no matter which entry is selected.



Any help is greatly appreciated.

[CJ_London]

sounds like you combobox rowsource is say

SELECT FirstName, LastName from myTable

and myTable contains

FirstName..LastName
George......Harrison
Harry........Smith
Paul..........Jones
Paul..........Smith

So when you select Paul Smith, Jones is displayed

Is this correct? If so, you need to include the unique autoID for the record in your rowsource and make it the bound column

If not, please supply

1.the sql to the rowsource,
2. some example data the sql produces which will illustrate the problem
3. the values for the bound, columnwidths and columncount properties for the combo

[Brightspark98]

Hi there,

I don't have access to my home pc at the moment so can't supply any further data. But
My table/ combobox contains for example..

Apples
Bananas
Oranges
Pears
Melons

If Pears are selected Apples are displayed.
If Oranges are selected Apples are displayed. and so on.

Thanks

[CJ_London]

too little info to provide a solution, please respond when you can supply the requested information

[Micron]

There is probably a requery of the combo that is taking place in an event.

[Missinglinq]

There is probably a requery of the combo that is taking place in an event.

That would be my first guess, as well, given the presented info!

Second guess would be a corrupted Combobox. Although we usually think of Forms, and even entire Databases, when we speak of corruption, Controls, such as Comboboxes, can and do become corrupted, and seem particularly susceptible to this during app development.

The test/cure for this is short and simple...delete and then re-create the Control.

Linq ;0)>


Linq ;0)>