I don't know your tables structure, but try use following SQL with your modificiations:
Select * From Orders Where Customer = '" +Combo1.Text+"' And Status = True
I hope Status Field is Boolean Type. Drop me a line if you want know more.
------------------
The Bozena




Reply With Quote