I know this answer is probably an obvious one but not to me at the moment so...
I have a sub-form which allows the user to add new entries to a table. When a new record is added I want to carry out various automatic procedures based on the values of this new record.
This processing can only occur once ALL the values have been added to the new record. So I thought the AfterInsert event would be the one to use.
The trouble is for the After Insert event to be triggered the user has moved off the inserted record so that it is no longer current and I can no longer access the appropriate data.
How do I (or is it possible to) access the data in the inserted record once all the req fields have been completed.
It is a multi-user DB so others may me adding new records to this table also.