I've a query where I keep some fields:

btw
excl
incl
total

I use this query as subform, now here 's my problem

I've got a textfield 'total' where I want to calculate the total from
the query for the loaded form.

I've used the expressionbuilder to perform this:

=Sum([subfrm FaktuurTest].Form!Inclusief)

When I see the form in 'formview' I get the following message:

#Error

Someone got any id?

Is [subfrm FaktuurTest] a Subform? If so, you must refer to it like this:

Forms("NameOfTheParentForm").Controls("NameOfTheSu bformCONTROL).Form.Control
s("NameOfYourControl")

"Bart" <bart.gybels (AT) skynet (DOT) be> wrote

bart.gybels (AT) skynet (DOT) be (Bart) wrote in message news:<84901bde.0312020214.af1480f (AT) posting (DOT) google.com>...
Hello Bart.

I'm not quite sure where you have your field located with
the above expression. Sounds like it's on the main form and
not the subform.

Perhaps you should make sure it's in the subform's "Form Footer"
to get the sum of the required field data. Then, on the main form
set a reference to the text field on the sumform.

Example for Sub Form: Make a text box called txtSumData
Source: =Sum([subfrm FaktuurTest].Form!Inclusief)

Example for Main Form: =[subfrmName].[Form]![txtSumData]

Regards,

Ray

"Scott McDaniel" <scott (AT) NO___Spam--thedatabaseplace (DOT) net> wrote

or simpler....

Forms![ParentForm]![SubformControl].Form![Control]

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

Tnx, this seem to be the problem

Bart

raycait (AT) excite (DOT) com (Ray) wrote in message news:<20ba9f4a.0312030217.6ef56219 (AT) posting (DOT) google.com>...