Form / Query issue

[asmith]

Hello everyone,



I'm having trouble with a form / query combination and request your assistance. What i'm trying to do is have the "LOC/Trust" number from "Input SubForm" feed into a query and then return the results back to the form. I have tested the query and can manualy plug in a value and the query results show up find in the query but when i try to assign the query to a text box it comes up the the "#Name?" error. Esentialy what i'm trying to do is make a running total for the different components listed in the subform based on the LOC/Trust Number that is linked to the main form.

I hope this makes sense and that you can help. I've attached a zipped copy of the database for you to view.

Thank you,
Andrew

[NTC]

Did not look at the attachment. Do not know what is meant by "assign the query to a text box "

General input: A query can be the record source for a form. Which would be 'assigning' perhaps.

Or - a query can 'call' a form's textbox value for its criteria. To do that one must use the correct syntax: Forms!FormName.TextboxName

To design a database & queries you really need to have a textbook in the version you are using. Easily available at Amazon or any big book store. They will have examples of these type tasks.

[asmith]

Thank you for your reply NTC.

What i meant by "Assign the query to a text box" is the following.

I added a text box to the form and under control source i added the following code:

=[Query1]![SumOfOSLR Current]

The SQL code for the query is as follows:

SELECT Sum(Table2.[OSLR Current]) AS [SumOfOSLR Current]
FROM Table2
WHERE (((Table2.[LOC/Trust Number])=[forms]![Input SubForm]![Loc/Trust]));


I hope this helps you understand my issue better. I have a copy of the Access 2007 bible but i can't find exactly what i'm looking for.

Thank you,
Andrew

[NTC]

One can not call a query into a form's control with =[Query1]

You can make the form's record source to be that query. or a derivative of this same concept by making a special form with that query record source and inserting it into the main form as a subform.

But I think what you most likely want to do is to use the DLookUp method. That will enable you to insert a specific table/row/field value into an unbound control (textbox).

Hope this helps.

[asmith]

Thank you NTC

I was able to use the DSUM Function to complete my task.

For others reference, the control source used in the solution was as follows:

=DSum("[OSLR Current]","Table2","[LOC/Trust Number] = Forms![Input SubForm]![LOC/Trust]")

Thanks again,
Andrew