Setting a Textbox Record Source

[carterlangley]

Hi all,

I would like to put a textbox onto a form that displays the value from a query I have.


Now, whenever I put the control source of the textbox to the query, it is coming up with a #name error.

This is the sql behind the query

SELECT Department.DepartmentName FROM Department INNER JOIN Client ON Department.[DepartmentID] = Client.[DepartmentID];

That returns fine

Just to now get that returned value into a textbox. Any ideas please?

[ranman256]

in the form property: RECORD SOURCE gets the query.
in the form ,display the property of the textbox,
data tab
set CONTROL SOURCE, to the field in the query the box will show data from.

[carterlangley]

Thanks ranman256
You've put me on the right track to get this solved.