Pls Help

I have 2 Tables : Header and Details

tblHeader
ProductId (PK)
Quantity

TblDetails
date
ProductId
Purchase Qunatity

I have a input form for Details and
I need to update the TblHeader[quantity]
using code
I now that the following is not correct

aa=tblHeader[quantity]+[Purchase Quantity]

What is the correct statement?
Thanks

aa = tblHeader![quantity] + tblDetails![Purchase Quantity]

This assumes you have both recordsets open and the record set names are
tblHeader and tblDetails

"loizos" wrote:

> Pls Help
>
> I have 2 Tables : Header and Details
>
> tblHeader
> ProductId (PK)
> Quantity
>
> TblDetails
> date
> ProductId
> Purchase Qunatity
>
> I have a input form for Details and
> I need to update the TblHeader[quantity]
> using code
> I now that the following is not correct
>
> aa=tblHeader[quantity]+[Purchase Quantity]
>
> What is the correct statement?
> Thanks
>
>
>