I have code running to insert data to a table based on whether or not the [DateOfIssueSB] is Null or Not Null.
If Null then I want to run strSQL = "INSERT INTO tblLCAmendHistory code
If not Null then I dont want to run it.
It seems to run all the time meaning that if it is both NULL and NOT NULL [DateOfIssueSB]. I only want the INSERT to run if NULL.
I had the code on both the AFTERUPDATE and BEFOREUPDATE thinking that I should not have th code on BEFOREUPDATE but rather AFTERUPDATE.
When on BEFOREUPDATE it would not give me the error of "VARIABLE NOT DEFINED" but after putting that code on AFTERUPDATE it gives me the error.
I am thinking that the code should be on the AFTERUPDATE and it will INSERT only when ISNULL [DateOfIssueSB] but I do get the error msg below when doing this.
Any ideas on how to INSERT only if ISNULL [DateOfIssueSB]?
the form is in continous forms mode