Hi,
Basically i have a form with some fields on; after fillingin the required and saving the user has an option to continue to fill more data on a second form.
The form is opened and the ID number is copied from the original (hence the need to save first) this then allows the user to enter against more fileds attached to that record.
The problem is when i come to try and save of exit it. For some reason i get an odbc call fail:
cannot insert the value Null(3306) into datelogged, js pastoral log, insert fails (515).
the date logged is a field only on the original form and not on the new one- and i onkly get the error on the new form not the original one, also the field is populated once the user starts to write (using the environ function)- so is a timestamp which doens’t allow nulls and will always populate with a value-
for some reason when trying to write back against the record its seeing the date logged value as null- even though it isn’t- ive changed the ‘allow nulls’ value on the table column to bypass this but it then does the same with the next field which wont allows- ive tried copying the field to the new form and looking at what the value is when its on the new form and all is fine so im at a loss as to why access sees this as a null and throws up an error.
any ideas?
greg