Help.. Form not working

Sniper-BoOyA-

Registered User.
Local time
Today, 08:42
Joined
Jun 15, 2010
Messages
204
Good Morning,

I could need some help with the following Query :

Code:
SELECT queryverdgrdzand1.tbllabgegevens.monsternr, queryverdgrdzand1.tblverdgrdzand.monsternr, queryverdgrdzand1.schaalnr, queryverdgrdzand1.massaschl, queryverdgrdzand1.massaschlmonnat, queryverdgrdzand1.td1, queryverdgrdzand1.massa1, queryverdgrdzand1.td2, queryverdgrdzand1.massa2, queryverdgrdzand1.td3, queryverdgrdzand1.watergeh, queryverdgrdzand1.massa3, queryverdgrdzand1.osczand, queryverdgrdzand1.opmverdzand, queryverdgrdzand1.tblverdgrdzand.laborant, queryverdgrdzand1.optimumwatergh, IIf(IsNull([osczand]),"",DLookUp("[inhosczand]","[tblosczand]","[oscnr]=" & tblverdgrdzand!osczand)) AS inhsczand, ((tblwatergehalte!massa3-tblwatergehalte!massaschl)/[inhsczand])*1000 AS drgdichtheidzand, ([drgdichtheidzand]/[drgdchthd])*100 AS verdgrdinsitu, querymaxtotaal.watergehproct AS optimumwatergeh, querymaxtotaal.MaxVandrgdichtheidproct AS drgdchthd
FROM queryverdgrdzand1 LEFT JOIN (querymaxtotaal RIGHT JOIN tblproctor ON querymaxtotaal.proctorID = tblproctor.proctorID) ON queryverdgrdzand1.tbllabgegevens.monsternr = tblproctor.monsternr;

This query is the source of a form, but when i open the form, i can not add / edit any data. Do you know why?
 
If you open up a query using the same sql are you able to edit the data, me thinks not. It looks like an non updateable query.
 
Youre right. Looks like a non updatable query. The question is, how do i turn it into an updatable query ? :P
 
Link your form directly on the table.
 
Aah ofcourse.. Ill have a look.

Ill keep you updated!

edit : Turns out, Querymaxttotaal is the problem. Looking further into it.
 
Last edited:
looks/sounds like your joined query maxtotaal is a totals query. as such, it is automatically non-updateable
 
Ya i might just split the form/ query in a way that first the user can enter data, and that data will be saved etc... Then i am thinking of making a button to start the calculation (on a second form). Because i really need the query maxtotaal.
 

Users who are viewing this thread

Back
Top Bottom