Form with data from a query and a table

[dpasanen]

I'm having trouble trying to get data from a table and a query onto the same form.
I use the table for most of the data, but there are a couple calculated fields on a query that I want on there as well.

Whenever I point to the query field for the text box, I get: #NAME?

I've got a relationship set up between the two that should be correct.

Any help would be greatly appreciated!

[jzwp11]

It would be better to use the domain aggregate functions to pull data from the query into the form. I assume that the data in the query is related somehow to the data shown in the form, so you will need some criteria. There are several domain aggregate functions, I assume that you will want the Dlookup() function. Some of the other common ones are DMax(), DMin(), DAvg(), DCount().

The control source for your textbox would look something like this. The syntax of the domain aggregate functions is a little tricky, so please take a look at the help section and it would be best to use the expression builder when first starting out.

=DLookup("fieldname", "queryname", "fieldname=" controlname)

[dpasanen]

Ah, perfect! Thanks jzwp11!

[jzwp11]

You're welcome