They're not quite the same query... one has a where clause while the other doesn't... try removing the where clause off of the VB version of the query.... see if you get results then.

If you do ... two things... 1) make sure you're using a valid value for the lookup. 2) use a parameterized query instead... there's info on that in the FAQ/Tutorial section of the Database forum.

-tg