Pesky #Name? errors

[Paul Gross]

Is there a simple reason why a select statement that
works as a row source in a list box won't work in a text
box? (I get the #Name? error).

The select statement returns a single field:
SELECT testbench.Benchmark FROM testbench;

The form is bound to an unrelated table fyi. I'm using a
bunch of unbound controls in this way to get control over
the display of info from another table.

Thanks for any help.

Paul

 

[Duane Hookom]

Control Sources don't accept sql statements. You could use:
=DLookup("BenchMark","TestBench")
This will return the BenchMark value from one of the records in your table.