Updating an unbound text box

[BrandonM30]

Hey all,

I have a problem with my database.

I am trying to update an unbound text box with a query field after the query updates. I am having no luck setting the control source in the text box, as I just get the #name? error.

I have the update function running, and I have the data I want being tabulated with accurate numbers. Now how to I get the data in the query to reflect in the forms text box?

Thanks in advance for your help.

-Brandon
:banghead::banghead::banghead:

 

[MarkK]

setting the control source in the text box

How are you doing this? Design view of the form? Code?

 

[BrandonM30]

I am running a macro that will update all my main queries and then take the data from the individual queries and input them into different text boxes on my form.

I can see the query data, and the update function runs fine, I just don't know how I tell MS Access 2002-2003 to take the query data and link it to the textbox.

 

[missinglinq]

You can't directly assign the results of a Query to a Textbox...you'll have to use DLookUp() to assign the value of the appropriate Field, from the Query, to the Textbox.

Linq ;0)>