Combobox defaults to 1st item on the dropdown list.

[wehoscottward]

Hello.
My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list. Any help would be appreciated.
Thanks, Scott

 

[bob fitz]

Hello.
My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list. Any help would be appreciated.
Thanks, Scott

Are you saying that if you select say the third item in the list it changes to the first in the list?

Do you have any code in any of the events of the combo box that could be causing this to happen?

 

[spikepl]

This error can occur if the values in the bound column are the same.

 

[wehoscottward]

Hi, Bob.
Thanks for your response.
The only code I have in my combobox [Combobox2] is the following in the Row Source Field.
SELECT [Find Member's WRCA Hx].Referral_Date, [Find Member's WRCA Hx].Member_Name, [Find Member's WRCA Hx].Member_ID, [Find Member's WRCA Hx].Account, [Find Member's WRCA Hx].[Assigned WRCA], [Find Member's WRCA Hx].[Case Closed], [Find Member's WRCA Hx].[Case Closed Date] FROM [Find Member's WRCA Hx] ORDER BY [Referral_Date] DESC;
To my knowledge, this is the only programming in Combobox2. There is nothing on the Event Tab. By the way, the name of the parameter query in Combobox2 is [Find Member’s WRCA Hx].