Combo box not keeping the selected value.

[PuddinPie]

Hello,

I'm using A2007 and I have a combo box thats record source is a query. It populates fine but when I select something in the list it always goes back to the first item in the list. How do I get it to stay on the item that I've selected?

Thank you.

 

[sparks80]

Hi,

You will need to provide some more information before anyone can answer your question.

Firstly can you give some details about the query for your combobox, if possible post the full SQL code.

 

[missinglinq]

What, exactly, do you mean when you say "when I select something in the list it always goes back to the first item in the list?"

Is the Combobox bound to a Field in the underlying Table?

Linq ;0)>