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
AccessVandal - 03 May 2007 10:52 GMT
Hi Emily,
Sum is a reserved word in Access, please rename this variable.
>Below are my VBA coding:-
>
[quoted text clipped - 10 lines]
>Eg QtyText Box = 1 QtyKitted=1
> QtyTextBox = 4 QtyKitted=5