Hi there,

I have an main table where i put my contrat details, such as:

Sale Date
End Contract Date
Type of product
Renew Date

This "Renew Date" depends on the number of months that i put on another table. The "Type of product" is linked to another table, where i define the "Group of Products". The number of months is writen here, by Group of Products.

So, the Renew Date is calculated on the number of months of Group of Product before the "End Contract Date".

I've tried this with Query and it works.

But i need to put this directly on the Table where i have the contracts.

There's a way to put this on Expression Builder?

Regards in advance...

make the entry form from a query of the contract and the product
with the link between them being the key field.

then after you type the product in , it will cleverly look itself up and find the months for that product.

then you have an after update event on that field.
then you write code like this
me.renew_date = 0
x = Val(Me.months * 30) + now()
me.renew_Date = x

there may be minor flaws in whats here but thats basically it.
i did a test with numbers rather than dates , so that could be slightly different.