>Thank you. I will try the same code. I tracked my problem to the fact that the command specified in the BeforeInsert never fires (I put some bogus field name but no error occurred). I even "bypassed" creating a SP and assigned value but still no luck. Puzzling ..

Did you call tableupdate after insert? Did you put some messageboxes in the BeforeInsert method of the CA?