DLOOKUP get Data from Form in Access (1 Viewer)

[ZKHADI]

hy buddies....

i am trying to get data from a subform textbox which is not existing in table.
on main form i am trying to get the data. but its not working. where i am wrong see image

 

[June7]

Domain aggregate functions pull data from table or query not form.

You reference textbox like: =[subform container name].Form.textboxname

 

[arnelgp]

maybe use same Expression for your mainform's textbox:

=dLookup("totals", "Expendaturefrm")

 

[June7]

I am guessing subform calc is: =Sum([Amount])

 

[ZKHADI]

Domain aggregate functions pull data from table or query not form.

You reference textbox like: =[subform container name].Form.textboxname

not working

 

[ZKHADI]

I am guessing subform calc is: =Sum([Amount])

this not

 

[ZKHADI]

maybe use same Expression for your mainform's textbox:

=dLookup("totals", "Expendaturefrm")

no

 

[June7]

Then what is it?

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[ZKHADI]

yes sure i will send here

 

[ZKHADI]

here id db. no confidential data.... just dummy data inside....

 

[Lampje]

=[Expendaturetbl]! [Totalen]

 

[ZKHADI]

=[Expendaturetbl]! [Totalen]

data picking from subform not from table

 

[Lampje]

Data comes from the Subform see image.

 

[arnelgp]

see the total on the lower portion of the main form.