Clearing a combobox selection not whole recordset

[EternalMyrtle]

I would like to be able to clear a combobox selection with code but nothing I have tried is working. I have searched for the answer and tried numerous suggestions and still nothing works. So I turn here...

Most recently I have tried this:

Me.cboCompanies.ListIndex = -1

To no avail. The selection still remains highlighted in the control after the code is executed. I want the control to be blank. Also the control goes from being a combo box to a text box until escape is pressed and it is cleared

I have also tried using a simple Undo and that is not working either.

Thank you for your help.

 

[pr2-eugin]

How about..

Me.cboCompanies = ""

 

[EternalMyrtle]

That was the first thing I tried

I also tried

Me.cboCompanies.Value=""
Me.cboCompanies=Null
Me.cboCompanies.Value=Null
IsNull (Me.cboCompanies)

It's such an annoying problem not mission critical but annoying!!

 

[pr2-eugin]

Hmmm, that is a bit bizarre. Is it bound or unbound?

 

[EternalMyrtle]

It is bound and a lookup to a table. The bound column is the PK so it is a number. Could that be why??

 

[EternalMyrtle]

I figured it out. It is happening because the recordsource is not a simple table but a query. The second table in the query is messing it up.

I need it to be a query to accomplish what I want it to do so I will have to think about this some more.

Thanks for your help!!

 

[pr2-eugin]

Ah ! Glad you have it sorted !

 

[EternalMyrtle]

I think it is because of the join (left join).

 

[EternalMyrtle]

So after all that, it turned out that my yes/no message box was coded incorrectly. Had I given you all the code from the beginning, you probably would have found it.

Lesson learned!