Hi,


This is my first thread on this site, so please forgive me if my query is in the incorrect section or if it is completely unrelated to this site.

I am using an independent program named MAROS v3 used for groundwater/hydro geological contamination modelling which runs through Microsoft Access. There is no support offered as it is free and unfortunately it is rampant with various debug errors/issues. I have a had a few so far, and the most recent has in turn prompted me to subscribe and join this forum to seek any help that may be offered.

The most recent debug issue was 'Run-time error '94': Invalid use of Null.

Selecting debug revealed the error to be found within this code:

oldvalueto = DLookup("SampleEvents", "tblSampleEvents", "EffectiveDate=#" & DMax("EffectiveDate", "tblSampleEvents") & "#")

Any help in relation to this code issue or where I may find alternative help would be greatly appreciated.

Thank you for your time.


CameronJ