Pesky #Name? errors

  • Thread starter Thread starter Paul Gross
  • Start date Start date
P

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
 
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.
 
Back
Top