What I want to do is put a StateCombo Box.  On the Querry, Forms!InputF!StateCombo criteria under StateID...Works great until I leave it null.  In that case I want to show all the states... In VB Code I can do this but I can't in SQL... Seeing how I want to create a querry to export into Excell, I need to know how to make it so I can select all the records or some by state.  Any tips advice?   The State: StateID & "" I don't seem to have any success with.  In short if the Combo is null than pretend there is no code under the criteria and show the records of all the states as if it weren't a factor.

---

Reply from Alex Hedley:

Can you not use VBA?
If Me.YourCombobox = "" Then
    'Place code here to address selction of
End If

You could have a * as the all and pass that to your query with a LIKE