Search results

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! :confused:

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...

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...

Thanks, I was able to get this to work. Turns out I had the event in the wrong OnFormat section. Cheers! :)

Hello there, hoping some VBA wizard will be able to help me. I have a lengthy CASE statement in my database that displays specific text in a field based on the value of another. Simple stuff but for some reason it randomly will not work on certain values, and never the same one twice. Is...