Query Criteria from Combo Box

[sherlocked]

So this is a sticky one! I have a combo box on my form that passes criteria to a simple select query. There are four possible selections to make from the combo box. For some reason, when I select the first option on the list the query runs perfectly. However, if I select the second, third or fourth option from the combo box, the query returns no records, even though I know there are records in my table which should be returned. What am I missing here? Your help is appreciated :banghead:

 

[sherlocked]

Hi,

The row source is four values: "Value1", "Value2", "Value3", "Value4"

The sql of the query is literally just select [fieldname] from [thistable] where [fieldname] = forms!frmname!comboboxname. It's a very simple select query.

That's why it's so weird to me that the first value works fine, but the others don't!

 

[sherlocked]

Hi,

I get the results just fine when I run a query using the values as single criteria.

I'm really stumped here. The first value on the list works great.

I even deleted the combo box completely and re-created it thinking that it might be a glitch!

 

[JHB]

I should work so something else cause the problem, post your database with some sample data + name of the form and query, zip it because you haven't post 10 post yet.