Reference query results in a Main Form

[Mischief1]

I would like to reference a field from a Totals query named: [s- PotableWtrMainsCompletedSinceLastReport]. The field is named: [Length].
I want to reference that field on a Main form but am not having any luck. I know I'm probably mixing up the syntax. Hopefully someone can help. Thanks :-)

[June7]

Show what you have attempted.

Options:

1. include query in form RecordSource

2. DLookup domain aggregate function referencing the Totals query or a DSum referencing the raw data table/query

[Mischief1]

Thanks for your quick response. I think I need to be more specific. I apologize.
There are two queries that I am actually trying to access from the main form so adding the query to the data source for the form won't work. Both queries are totals queries which access two separate data tables and they both have a parameter being run for the user to enter a [> date]. I tried the DLookup but I don't think it works when the query has a parameter in it.
If this isn't clear then I will have to clean up the database for sensitive information and attach it. Thanks again for your help!!

[June7]

I never use query popup parameter input - too hard to validate user input. Better to have form for input and query references form control as parameter. Then I think the DLookup will work.

[Mischief1]

I don't really have time to re-engineer the form if possible. I'm not sure how to create the method you suggest. I have always created parameters right in the query. What would the process be to use your method?

[June7]

Query parameters reference controls on form. For user input the controls would be unbound, in form header section.

Review

http://datapigtechnologies.com/flashfiles/buildcustomfilter.html
http://datapigtechnologies.com/flash...earchform.html

[Mischief1]

OK. I created an input form to capture the parameters for the dates and modified my queries to grab them. The DLookup fuction now works on my original Main form, however, those numbers are showing up as 0 on my report. I am using a =Get() function to retrieve them because my main report is bound to a crosstab query. I am also pulling several other numbers that are variable and need to be entered manually and those fields are also being retrieved with a =Get() function. The only piece left now is to get those two numbers that are being retrieved with the DLookup to show up properly on my report. Sorry to be such a pain. I appreciate your help!!

[June7]

Why are they 0 on the report? What is the textbox ControlSource? Is it a DLookup or is it reference to control on form? Get() is a custom function? How does this retrieve data? Show the function code.

If you want, can provide db for analysis. Follow instructions at bottom of my post. Identify the objects involved in issue.

[Mischief1]

My database is larger than 2MB even when zipped. I have taken screen shots of my code and attached it. Hope this helps.

[June7]

Too hard to follow, can't test code.

Those globals and functions are in a general module?

You ran Compact & Repair first? Could make copy and remove most data.

Alternative is upload to a fileshare site such as Box.com and post link to the file.

[Mischief1]

I figured it out...I think... Thanks for your help!!