Hello fellow access users. I am attempting to save a record within script of the after an update event to allow another procedure to take place based on saved new details of the field
Example: On the status changing to Completed, today date is inserted into the Date completed field of the form. This runs correctly, but is not save until I leave the record.
Following this I have an append query to create a new task based on the date completed.
The append query has criteria for a date and if the record has not been saved the date field is blank and the new task is not created.
Any advice would be appreciated
Example: On the status changing to Completed, today date is inserted into the Date completed field of the form. This runs correctly, but is not save until I leave the record.
Following this I have an append query to create a new task based on the date completed.
The append query has criteria for a date and if the record has not been saved the date field is blank and the new task is not created.
Any advice would be appreciated