How to display select query result in a text box 1

[jrollins]

I created a select query that produces the correct dataset when the query is run directly. I have a text box on a form to display the query results. I went into the ControlSource property in the text box and used Expression Builder to select the field within the query that I want to display. When I open the form, the text box contains #Name?. Is this not the right way to display query results in a control?

 

[RoyVidar]

Hi!

Short answer: No.

Perhaps one of the Domain Aggregate functions might work in your situation, for instance:

[tt]=DLookup("[Field Name]", "[Table Name]", "[Some Field] = 'SomeText'&quot[/tt]

Table Name, could also be a query, the criteria part might be ommitted...

Look it up in help, or post back with table/query names...

HTH Roy-Vidar

 

[bitmite]

use a list box this control is designed to show query results

 

[jrollins]

DLookup worked! Tried a list box, used Expression Builder to select the field in the query that I want to display but when I opened the form the list box was blank.