Using current length

[MartynE]

Uhh when I try that I can't leave the column of the query it says it's missing a operator.

Indeed I've been working hard, the sooner this is done the sooner I can go spend my free days..

 

[CJ_London]

sorry - I didn't correct all of them - need a strong coffee

nz(DSum("AF_lengte+AF_zaagbreedte","VRMUTSTAF","VR ID = " & [VR].[VRID]),0)

 

[MartynE]

Tried that before u posted that, how about you take that coffee

It gives the same syntax error. ( I work in Access 2003 )

 

[CJ_London]

It definitely requires comma's. Some other things to try

1. try using square brackets "[AF_lengte]+[AF_zaagbreedte]"
2. Your code has "VR ID =" - shouldn't this be VRID? and if spaces do exist in the name you must use square brackets

 

[MartynE]

Tried both, the problem is that it tries calculate [used] while no autonumber is given yet.
I have no idea why it should give a autonumber field to VR.VRID since it's determined by the record you are in. So it should be filled in already..

I tried in the criteria: Forms![VR01:Voorraad Staf]![VRID] but it keeps being autonumber

 

[CJ_London]

can you post a cut down version of your db, I'm sure it is something simple - sometimes a fresh pair of eyes can see the obvious...

 

[MartynE]

I just gave up and just make a button to make mutations and show the previous mutations in the subform. I think that is just the easy way out. Thanks for your time and help!

 

[CJ_London]

Good luck!