SQL statement for a Combobox

[Beany]

I have a combobox that has a list of sites.............

selecting a site brings up all the site details in a form..................

there are several fields within that form including a status field.

The status field includes live, cancelled, pending .

What i want to do is, if any site has a status of cancelled , it shouldnt list it in the combobox...............how do i do this?

ive tried the following SQL statement.......... it doesnt work

SELECT [tab_data].[site] FROM tab_data WHERE status != cancelled  ORDER BY [site];

 

[Rich]

<> "Cancelled" in the criteria field for Status in the underlying query

 

[Beany]

rich ---------> a star!