Yes , no problem.

Hi Todd,

I agree with what you're saying, that's the reason why I wanted to create the reference field in a trigger

I'm getting the record ID , unfortunately the RC recordset...

Hi,

I tried this as well,

but somewhere something is wrong.

On my form, the record ID is generated on save, then can not

be recorded. before saving :doze:

Hi Todd,

I'm a bit confused on how to save and select the primary key again.

I'll look at this tomorrow ...

Thanks again ! 🙂

I'm turning around any valuable solution... 🙁

To finish, I've changed my reference field as a calculated field.

The trigger now is used only to send the email.

In this case, its working...

Hi Todd,

Thanks for your reply, but unfortunatelly your solutions are not working

The refresh action is clearing the #deleted#, but it moves to a new record as

the form is in DataEntry...

Hi Lutz,

Thanks for your reply.

I tried to requery, refresh whatever was possible and it's not working.

The problems seems to occur when the data is saved from access, I mean

when I...

Any idea ? :crying: