Possible: Select field1 where field2 not in (cursorName) ? 1

[shelbytll]

I have made a select statment and store in cursor tempcur.
I want to make another select statment where field1 Not In tempcur.

Is it possible?
for example:
select field2 from tablename where field1 not in (tempcur) I am a clever newbie...

 

[shelbytll]

If not possible, how about does combo box has an ItemExist function so that I can do a check whether this value exist before I AddItem. I am a clever newbie...

 

[rgbean]

You may want to just use a simple sub-query - no temp cursor necessary.

select field2 from tablename ;
 where field1 not in ;
 (select field3 from table2)

Rick