code in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top