Calculate

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

Below are my VBA coding:-

Sum=sum+1
Me!QtyKitted = sum

My textbox is QtyKitted.

But the problem is my control source is QtyKitted because I need to use it to
generate query.

May I know how to make the textbox to accumulate?

Eg QtyText Box = 1 QtyKitted=1
QtyTextBox = 4 QtyKitted=5
 
Hi Emily,

Sum is a reserved word in Access, please rename this variable.
 
Back
Top