Query works in SQL8+ but not forms debugger

[GreatBloke]

Hi,

I have a select query which works perfectly in sql8 but when i have a combo on a form no data is displayed (i'm sure the combo is setup right).

When i go into the forms debugger and enter the same select i get no rows selected.

All help is very much appreciated
Thanks

 

[Ziyad]

In the combo box you have check the elements given if that elements is not mached with the fetched values the query wont return any values.Set the property mapping other values accordingly