Textfield is the field name... are we not saying the same thing? The textfield is not the same for both the variable and the temp test table. If you remove the temp table and use a sub-query, it makes the issue less confusing.

You'll excuse me... I'm griping. I don't like the way the question was worded. Should have said that in the first place.